Excel Number Format Question

S

snolte

How do you keep the zero in front of a number when the cell is formatted as a
number(example 01423)? This needs to stay formated as a number for importing
reasons.
 
D

Dave Peterson

I'm not sure what that last sentence means, but you can use:

Select the range
(in xl2003 menus)
format|cells|number tab
custom category
00000
 
Top