How to add leading 0 to four digit number?

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

Guest

I have a column of Zip codes in an Excel spreadsheet. Some of the values are
4 digits in length and some are 5 digits in length. I need to have the
column in text format, but since the format was numeric the leading zero
disappears. I need a formula that determines that if the length of the value
is 4 characters than add a leading zero.
 
Hi

With numeric code in cell A2
=TEXT(A2,"00000")
With variable length numeric string as code in cell A2
=TEXT(VALUE(A2),"00000")

Arvi Laanemets
 
Back
Top