I have a column from a text file as '0000000045788999' and I need to do the following:
1. need to perform a decimal validation on it for decimal[18,2].
2. For this I am dividing it by 100 to see if its a valid decimal
3. then set T or F based on the outcome.
When I divide by 100, its becoming as 4.5789e10^5. So, its taking an exponent form and this is failing the validation. How to make it avoid taking the exponent form. Thank you.
Decimal Validation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore