Leading zeros in excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2493507%22%20slang%3D%22en-US%22%3ELeading%20zeros%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2493507%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20remove%20the%20leading%20zero's%20in%20my%20zip%20code%20column.%20I%20have%20tried%20everything%20to%20change%20formatting.%20It%20will%20correct%20while%20I%20am%20working%20in%20the%20file%2C%20but%20I%20save%20it%20and%20the%20zero's%20go%20away%20again.%20I%20need%20to%20work%20on%20this%20file%20and%20upload%20it%20to%20another%20system%20to%20send%20out%20mailers.%20Can%20anyone%20help%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2493507%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2493550%22%20slang%3D%22en-US%22%3ERe%3A%20Leading%20zeros%20in%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2493550%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1090120%22%20target%3D%22_blank%22%3E%40JillRipley%3C%2FA%3E%26nbsp%3BFormat%20the%20column%20with%20the%20zip-codes%20as%20text%20first%2C%20then%20enter%20the%20codes.%20Alternatively%2C%20type%20an%20apostrophe%20in%20the%20beginning%20of%20each%20zip%20code.%20If%20this%20doesn't%20work%20or%20make%20any%20sense%2C%20please%20upload%20your%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Excel remove the leading zero's in my zip code column. I have tried everything to change formatting. It will correct while I am working in the file, but I save it and the zero's go away again. I need to work on this file and upload it to another system to send out mailers. Can anyone help???

3 Replies

@JillRipley Format the column with the zip-codes as text first, then enter the codes. Alternatively, type an apostrophe in the beginning of each zip code. If this doesn't work or make any sense, please upload your file.

@Riny_van_Eekelen 

The file is a download from another system. I have no way to format it first. 

 

@JillRipley I see. Assuming you are on a PC, Excel opens a CSV file automatically, splitting the texts at the  comma's and applying what it thinks to be the most appropriate data type for the columns generated.

 

Rename the CSV file to one with a TXT extension. Then from within Excel, open the TXT file. A Text Import Wizard will open . In step 1, choose "Delimited". Press Next. In step 2 select Comma as the delimiter. Press next. Now select the column that holds the ZIP codes. It says "general" at the top. In the top left part of the window, select Text. Then press Finish. Now, the Zip column will have retained the leading zero's. See attached.