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.

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.

-----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