Automatic CSV Formatting

M

Mark Roberts

Hiya,

Does anyone know a way to stop Excel from automatially
trying to format a .csv file that it opens?

The problem is that we have a .csv file that has leading
zero's in some of the fields that are necessary, but when
opening in Excel these are stripped as it makes an
assumption that this is a number and the leading zero's
are not required.

Thanks in advance,
Mark
 
A

Andy B

Hi

One way is to rename your CSV to be a TXT. When you open this in Excel, the
Text Import Wizard will run, allowing you more flexibility with the import.
 
Top