How to hide unwanted zero from decimals

[former_member709690]

Hi,

may i know how do i hide unwanted zero from decimals, such as if i have value 3.4000 then i want report should present it as 3.40 but there is a value 3.4123 then i want report should present it as 3.4123.

Please advise.

[DellSC · Accepted solution]

To do this, you would have to create a formula that will convert the number to text for display. It would look something like this:

ToText({MyTable.NumberField}, '#.00####')

This would show up to 6 digits after the decimal if they're available and shows a minimum of 2 digits, including zeroes, after the decimal if there's only 1 digit after the decimal in the data.

-Dell

[former_member709690 · Accepted solution]

Hi Dell,

Thank you very much!

[former_member775661]

Hi muddasir89

In crystal report, select the field and right click, choose the format field and go to number tab. You can click customize for your desired format. Regards