Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I stop excel removing zeros?
Hi,
I'm opening a .csv file directly from a web page that has customer data in it for producing despatch labels for orders. Some American postcodes begin with a zero, and excel removes any leading zeros resulting in an incorrect postacode. If anyone knows how to EITHER get Internet Explorer to open the .csv in notepad, or stop excel removing the leading zero it would be appreciated. |
#2
|
|||
|
|||
Unfortunately, Excel is treating the zip code as a number and will
automatically drop any leading zeros. If you're strictly using this information in Excel, then format the column using the Special format for zip code (ToolsOptions, Number tab, Special, Zip Code). If you have an earlier version, you may have to use the Custom format and enter 00000. If you plan on exporting this data elsewhere, the leading zero will again be dropped because you just changed the format, not the actual number. "tomcat" wrote in message ... Hi, I'm opening a .csv file directly from a web page that has customer data in it for producing despatch labels for orders. Some American postcodes begin with a zero, and excel removes any leading zeros resulting in an incorrect postacode. If anyone knows how to EITHER get Internet Explorer to open the .csv in notepad, or stop excel removing the leading zero it would be appreciated. |
#3
|
|||
|
|||
-----Original Message----- Hi, I'm opening a .csv file directly from a web page that has customer data in it for producing despatch labels for orders. Some American postcodes begin with a zero, and excel removes any leading zeros resulting in an incorrect postacode. If anyone knows how to EITHER get Internet Explorer to open the .csv in notepad, or stop excel removing the leading zero it would be appreciated. . Format, Cells, Number, Text |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
Removing single quote from an excel sheet | Excel Discussion (Misc queries) |