number format to use 9 characters like 000040.00

[Former Member]

I have created a formula in a field to display YTD Salary in 9 character fixed width format like 001403.72 instead of 1403.72

It works fine on other fields and I am getting the desired result, but on YTDSalary field, on using the same formula I get the desired format in some records but in some records I get it as 01,403.72

see attached screenshot.

[abhilash_kumar · Accepted solution]

Hi Parag,

It also considers the thousands separator.

Try this code:

totext(YTDSalary_field,'000000000.00')

-Abhilash

[Former Member · Accepted solution]

Abhilash,

Your formula works, any reason why my formula is doing that, as it works for other fields ?

Thanks for your response

Parag