Automatic CSV Formatting

  • Thread starter Thread starter Mark Roberts
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excel CSV Files; Creating Of 3
Open csv file with Leading Zeros 1
How to stop Excel from automatically truncating leading zeros 2
leading zero & .csv files 4
CSV text data altered on file open 4
Single Quotation mark in CSV 1
Option for opening Excel .csv in text vs. general 5

Back
Top