Format number without decimal point

[Former Member]

Dear Members,

I have a problem formatting a number with "formatNumber".

I have to format it to 12 whole and 3 decimals, e.g. I get "17.5" and I should make it look like this:

"000000000017500"

Or "2583" should look like this "000000002583000"

So the decimal separator "." should be gone and decimals are represented by zeros if there are none in the original number.

Can I achieve that somehow with the standard function "formatNumber"?

Thank you very much for your help!

Best regards,

Peter

[Former Member · Accepted solution]

Hi,

you could do it like that:

input -> multiply with 1000 -> Format Num(000000000000000)

Regards

Patrick

Edited by: Patrick Koehnen on May 19, 2009 1:23 PM

[Former Member]

Easy trick would be to multiply the source value with 1000 first and then use formatNum with 000000000000000......15 times zero

use standard arithmetic function multiply

[Former Member]

Hi,

first I thought you don't want to use the decimals, but I fixed it now it should work.

Regards

Patrick

[Former Member]

Thanks a lot guys!

I chose to multiply my number with 1000 and then set the format and it works perfectly!

Thank you!

Peter

[Shabarish_Nair]

use the formatnum to achieve the require DECIMAL formatting and then use the text function replaceString to replace the . with empty string