Hey,
I got a bunch of number I am showing in the detail. I need them to display as 5 digits no matter what. If they are less than 5 digits I need them to have leading zeros.
IE.
999 should be 00999
anyone know how to do this in crystal?
Printable View
Hey,
I got a bunch of number I am showing in the detail. I need them to display as 5 digits no matter what. If they are less than 5 digits I need them to have leading zeros.
IE.
999 should be 00999
anyone know how to do this in crystal?
Create a formula and use the ToText function
ToText(123,"00000")
perfect, thanks!