Disable formatting on csv open?

  • Thread starter Thread starter Heather1270
  • Start date Start date
H

Heather1270

Hi!

When opening a csv file in 2003, Excel "formats" the data - it coverts
one field that is text but looks suspiciously like a date to a date
field. Is there a way to disable this or set Excel to open the file
with all fields formatted for text?

Thanks!
Heather
 
"Heather1270" <[email protected]>
wrote in message
Hi!

When opening a csv file in 2003, Excel "formats" the data - it coverts
one field that is text but looks suspiciously like a date to a date
field. Is there a way to disable this or set Excel to open the file
with all fields formatted for text?
Click to expand...

The easiest way is to rename the file to .txt instead of .csv, then the text
import wizard allows you to select the format for each column.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV->Excel Data Problem 1
Excel CSV Files; Creating Of 3
Losing date format when saving .csv files 10
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Open csv file with Leading Zeros 1
Number in text format in CSV file 3
.csv Commas ? 2

Back
Top