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.
tong wrote:
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!!
--
Dave Peterson
|