TEXT formatting should work fine........

Highlight the column, Right-click . FormatCells NumberTab select TEXT
OK........then enter your numbers with the leading zeros.....and all the
rest of the numbers........they will be all left-justified.

If you are copying something to the column, then use "PasteSpecial Values"
to prevent the formatting being changed during copying.....

Vaya con Dios,
Chuck, CABGx3


"Brent E" wrote in message
...
I've got an Excel workbook that contains many license numbers and I need
to
format the column so that if a license number has several 0s in front,
they
aren't automatically truncated by Excel. I tried general, number, and text
formats but they truncate leading 0s. Any ideas? Thanks.