Hi Team,
I need your help.
Can you please help me to format the number 0.999 (It is a fixed decimal) to .999 in string format?
Exaples
Number ToString (Final result)
0.999 .999
12.248 12.248
0.123 .123
Thank you in advance.
Thank you for your help.
But if I use trim(ToString([Field1],4),"0") formula it convert my 0.9900 value into .99.
I need whole four digit after decimal places.
I.e if my value is 0.9900 then my result value is .9900 not .99.
Thank you once again.
In that case, use TrimLeft().
I would use the Trim function in addition to the ToString function to trim the unwanted zero.