zip codes as numbers

  • Thread starter Thread starter VS
  • Start date Start date
V

VS

Hello,
I'm populating each Excel cell with data from a different database that has
addresses in it.
Zip codes that look like '01234' get interpreted as a number and the 0 gets
dropped.

How do I get the cell to read and enter the zip code into the cell as a
string?
Thanks,
V
 
Try formating the cell receiving the info as text - this
usually works for me when excel tries to make a number
into a date. Click on format, cells, and under the
number tab, choose text. Also, you can try the past
special option under edit
 
Back
Top