Seems the cells are full of text values notwithstanding you have only
digits.
Try in a separate cell entering 1234; then give it the custom format just to
be sure we are on the same wavelength.
Feel free to send me sample file (my private email not the newsgroup)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Chris" wrote in message
...
Yes, they are all composed of the numbers 0 through 9.

Prior to my posting my original message, I selected the entire column and
then applied a custom format of "0000000000" (as numerous online
references
was the way to do it--at least, for Excel 2003); however, nothing
happened.

"Bernard Liengme" wrote:

Are they all composed of digits only?
Then use Custom format such as "0000000000"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Chris" wrote in message
...
I have a text file with a column containing numeric codes. I need to
'pad'
the code values with leading zeros--so that all of the codes are of the
same
length. I imported the file into a new workbook, specifying the code
column
to be of type text.

I've tried every method and searched the web and newsgroups every way,
but
can't figure out how to pad the column. The many references for Excel
2003
don't seem to apply to Excel 2007. Can someone help?