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