Cube Long Arrow Right External Link angle-right Search Times Spinner angle-left

Disappearing Zeroes

Some lists will have ZIP Codes or other fields containing numbers and Excel will try its hardest to remove the leading zeroes when you convert the file to a .csv or upload it to Mailing Online.  To prevent that from happening, follow these steps.

1.  While your list is open in Excel, click File and Save As.

undefined

2.  Save the file as a Text (Tab delimited) file.

undefined

3.  Close the original file.  When the first Excel warning appears, click OK.

undefined

4.  When the second Excel warning appears, click Yes.

undefined

5.  Now you'll want to open the tab delimited file in Excel.  Click File and Open.  Note: Excel has to be opened first.

undefined

6.  Next to the file name field, select All Files.

undefined

7.  Locate the tab delimited file and click Open.

undefined

8.  The text import wizard will open.  Select Delimited and click Next.

undefined

9.  From Delimiters, select Tab and click Next.

undefined

10.  Highlight all the fields from the Data preview by clicking on them while holding the shift key.  From Column data format, select Text.  Click Finished.

undefined

11.  The file will open and you'll see the zeroes no longer disappear from the impacted column.

undefined

12.  Resave the file as a .csv.  Click File and Save As.

13.  Give the file a different name if desired.  Select CSV (Comma delimited) from the Save as Type field and click Save.

undefined

14.  When the Excel warning box appears, click OK.

undefined

The mailing list will now upload normally.