How to Replace left most zero with space and do not disturb other zeros

[pgayath1]

My requirement is:

replace the left most zero with space and retain other zero(s).

Example:

'0001' or '0000'

should be represented as

'001' or '000'

Please assist to identify a better solution

[markcurry · Accepted solution]

This should do it...

RIGHT([Numbers], Length([Numbers]) -1 )

Or if you want to make sure the first digit is 0, then this...

IF Left([Numbers], 1) = "0" THEN
        RIGHT([Numbers], Length([Numbers]) -1 )
ELSE
        [Numbers]
ENDIF