How to use the exact format in a csv file when opening a csv file

G

Guest

As captioned, in my .csv file, Field A is 02, Field B is 1.2%, Field C is
0.0, but after open in Excel, Field A becomes 2, Field B becomes 1.20%, Field
C becomes 0.
How to prevent Excel change the value format when opening a csv file?

Thx!!
 
D

Dave Peterson

I don't think you can.

But if you rename the file from *.csv to *.txt, you can specify each field in
the data import wizard. That way you could treat the 02 as text (not numeric).

But the 1.2% will come in the way excel likes.

A more common approach would be to just format the cells the way you want after
you import the data.
 

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

Loosing value of large number when saving file to CSV format 2
Preserving "trailing" zeros from csv file 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Number in text format in CSV file 3
["\r\n" new line command in CSV file] 1
Numbers change when saving as a csv fle 3
how to link ot a data in a csv file? 3
Cell format on reading .csv file 3

Top