Skip to Content
0
Former Member
Jan 18, 2011 at 04:17 PM

Any std funtion(s) for Zero-padded, 2 decimal value, without the deci point

34 Views

Hi,

We want Zero-padded, two decimal value, without the decimal point. For example if it is 14.31, we need 001431.

I have done "multiply" with 100 and "formatNumber" as '000000'

SFIeld --> multiply * 100 --> formatNumber (000000) --> TField

It works good for values with decimal like above 14.31, does it work for everything else too? I mean for 12 it is populating as 001200. Is this best approach? Is there any other std funtions or UDF sample available?

Regards,

N@v!n