Leading 0s and Col Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top