why does the zip+4 get deleted when saving and excel file as a DBF

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

Guest

Each time I try to export, to dbf, an address list created in Excel it
deletes the Zip+4 when in the xxxxx-xxxx format I need, Please help.
 
In my simple test, the digits didn't get deleted, but the formatting was gone
when I reopened the .dbf file in excel.

If I typed in the zip+4 as text (preformat the cells as text or started with a
leading apostrophe '12345-1234), then the text was kept in tact.
 

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

Save DBF in Excel 2007 2
Save as DBF 4 3
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010 0
How I can save sheets as *.dbf (in excel 2007)? 2
When will save as "DBF" be a reality from Excel 2007 ? 1
File Converter for Excel 2007 .dbf (Database III) 2
How do I save an excel workbook as a DBF file 1

Back
Top