Inserting Decimal in numeric field

[SR24]

I have a string field which contains numeric data with leading zero's. I've converted this field to a number field and removed the leading zero's but I am having some trouble inserting a decimal point so I can report the field as a currency amount. For example, the string would appear as 0000001125. I've converted this string to a number and removed the leading zero's so the numeric field displays as 1125. How can I insert a decimal so the field displays as 11.25?

 

[dgillz]

Divide by 100.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Turkbear]

Hi,
Maybe divide the number by 100 before the text conversion and use the formatting options of the ToText function to display it correctly?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Try a formula of:

val({table.field})/100

You don't need to strip out the zeros, just convert it to numeric and change the precision.

-k

 

[SR24]

Thanks for the quick response. It worked great!