Leading 0s and Col Formatting

[Guest]

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.

 

[Guest]

A couple of possible solutions... As a formula
=text(A1, "00000000")
which will convert the number to text and ensure that there are 8 digit
which would include leading zeros

Format Cell -> Custom -> 00000000

Which will change how the number is displayed. It is still stored as a
number without leading zeros, but it is displayed with the leading zeros.

HTH

 

[Chip Pearson]

Use a custom number format of 000000.


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