Excel Number Format Question

[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.

 

[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

 

[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