Need help for number format

[alt_tush]

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.

[StephenR]

I would use the Trim function in addition to the ToString function to trim the unwanted zero.

[alt_tush · Accepted solution]

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.

[StephenR · Accepted solution]

In that case, use TrimLeft().