001 is displayed as 1 in the cell not 001

[rodney]

001 is displayed as 1 in the cell not 001

 

[JE McGimpsey]

See answer to your previous post.

 

[NH]

goto cells>format>custom and type 000
This will display any number <100 as 3 digits