View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cj cj is offline
external usenet poster
 
Posts: 9
Default 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