Thanks guys, I'll try those ideas. I forgot about that apostope. cool. And
the customer sounds like a good way too, but I am curious, how do I do that
if the amount of leading 0s may be different for different numbers? Thanks
again guys.

"Michael" wrote:

Hi Brent
Put an apostrophe in front of the number, eg.

'00045879
this will enforce the zeros to be displayed


HTH
Michael
--
Michael Mitchelson


"Brent E" wrote:

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.