Excel keeping leading zeros

[rry2k]

Hi,
Is there a way to type 001 in a cell and keep the leading zeros diplayed?

Thanks..Russ

 

[DaleWatson123321]

Russ,

The easy method is to use Format - Cells - Number - TEXT

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[rry2k]

Thanks dale

 

[SkipVought]

Hi,

I would use Format/Cells/Custom - and then 00 in the Type TextBox for a display of 2 digits.

Skip,
metzgsk@voughtaircraft.com

 

[rry2k]

That's what I ended up doing. Thanks Skip

 

[technomama]

Just a thought, if you want to keep 001 as a number to use in a formula, you can create a custom format. If all your numbers will start with 00, you can create a custom format (format//cells//custom) "00"#

If you enter 1, the result will be 001. If you enter 27, the result will be 0027.

 

[rry2k]

Cool thanks