Page 1 of 1

handling fraction data

Posted: Fri Oct 31, 2008 1:41 am
by sathishmca
Hi all,

any one help me i this.I have a data.I need to get only 2 digits after fraction point

and one more thing is i need the same if the data has 00 after fraction point.


Ex:

123.456 = 12345
123.189 = 12318
123.00 = 12300

Please help me in this.
Thanks in advance

Posted: Fri Oct 31, 2008 5:45 am
by ArndW
INT(In.Column*100)