Select cells
Use Format | Cells; open Custom tab
Enter 000
If you wish you could then format | align | left
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"GKW in GA" wrote in message
...
Hiow can I convert a column of numbers from numeric to character and pad
with
2 zeros
e.g. I want the number 1 to appear as character 001