| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
load a CSV file and have it take all fields as text
Here is a sample line from the csv file I get
"2007-02-21 11:07:44.0","MCKINNEY","SC","1172084864684" When I double click the file it is opened in Excel but it comes in looking like 07:44.0 MCKINNEY SC 1.17208E+12 I want this data shown in excel exactly as it was read in. As you will note all the "fields" in the csv line are in "s to denote they are text. How can this be accomplished? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| automatically open .txt file with all fields as text? | Excel Discussion (Misc queries) | |||
| Can I load text file into Excel seting field delimter using cmd li | Excel Discussion (Misc queries) | |||
| File did not load completely | New Users to Excel | |||
| File will not load | Excel Discussion (Misc queries) | |||
Threaded Mode
