How to add leading 0 to four digit number?

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

Arvi Laanemets

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding recognised Zeros 5
Function to Count Zip Code Digits With Leading Zero 2
Format>Cells>Special>Zip Code 5
How can I get a leading zero (ZIP code) to show in a LEFT() calc? 2
Strip leading zeros 5
Need 7 digit number with differnt number of leading zeros 10
Leading zeroes formula 3
Force leading zeros 2

Top