How to display a number beginning with zero

[DeeKay]

I want to display a four digit number which may or may not begin with zero,
i.e. (0215) (0050)

 

[Pete_UK]

You can format the cell beforehand as Text, or you could type an apostrophe
immediately before the number, e.g. '0400 will display as 0400.

Hope this helps.

Pete

 

[Mike H]

Try

use a custom cell format of 0000
that's 4 zeroes

Mike

 

[DeeKay]

Thank you both (Pete & Mike) so much