excel

Adding a "0" to the beginning of a 4 digit excel cell to make it a zip code.

I have a row of numbers that are zip codes but because they all start with a zero (NJ) the zero gets dropped. ie. 07749 only shows as 7749. What formula can I write in another cell that will add a zero to the beginning of each of these? Thanks, Jerry.'Jeff

Solution

  • You can use TEXT like this with 5 zeros:

    =TEXT(A1,"00000")