View Single Post
  #1   Report Post  
tomcat
 
Posts: n/a
Default 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.