number format to use 9 characters like 000040.00
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.
YTDSalary.png
(3499 B)
Tags:
Abhilash Kumar replied
Hi Parag,
It also considers the thousands separator.
Try this code:
totext(YTDSalary_field,'000000000.00')
-Abhilash