Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use the exact format in a csv file when opening a csv file
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!! |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format of CSV File in export | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
file format needs to be changed | Excel Discussion (Misc queries) | |||
how to format and print labels from an excel file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |