Use a custom number format of 000000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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