Import zipcode from excel to dbf format without loosing leading zero's

[rollypac]

I have zipcodes that are in zipcode format in my speadsheet (06549, 05489). When I import or save them as dbf format I loose the leading zero's. Any ideas how to retain the leading zero's or add them after the fact? When they are in the dbf format they are characters.

 

[dcompto]

Is there a reason for not formatting the cells as Text in Excel? Doing so would retain the leading zeros when importing and exporting, and they will still sort correctly.

 

[rollypac]

The spreadsheet came to me with the zip code column formatted as special/zip code and when I reformat as text it removes the leading zero's.

 

[frainbreeze]

hello

try doing this:

select the column
go to custom
enter a 0 for each digit in the post code (i.e. 5 digit post code, enter 00000)
this will insert a lead 0 in all fields

for more info go to:

http://support.microsoft.com/defaul...port/kb/articles/Q214/2/33.ASP&NoWebContent=1