Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |