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

  • Thread starter Thread starter Guest
  • Start date Start date
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!!
 
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.
 
Back
Top