\0 will give you a leading zero but you must follow it with as many # signs
as you think you might need. It will not display unwanted zeroes. 025 will
display as 025 and not 000025.

"Marie" wrote:

In a cell I need to show codes with a zero at the left, how can do this
without having to format it as text first?