If you have a whole column to enter that way, then just highlight the
column, Format Cells NumberTab Text OK.........this way you don't
have to remember to type the leading apostrophe each time, nor do your
users........

Vaya con Dios,
Chuck, CABGx3


"spoggy" wrote in message
...
doing worksheet for ordering zeros at beginning of numbers disappear. How
do
I format to keep zero in group of numbers ie 04581