Skip to Content
0
Former Member
Apr 27, 2009 at 05:22 PM

Display 4 decimals only and remove trailing zeros

242 Views

Hello,

I have CR XI used in .net windows application.

I need a formula that will display a decimal value with minimum 2 decimals and 4 decimals characters (if needed) and will remove all trailing zeros.

Examples:

100 -> 100.00

100.1234 -> 100.1234

100.1200 -> 100.12

Thanks

Edited by: mtlmonk on Apr 27, 2009 7:22 PM