| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading from CSV date format
Hi there,
When I read from my CSV file the date column is in DD MM YY - its a string in the CSV file (with quotes). However when it comes into excel is MM DD YY. How do I stop this conversion from happening automatically. Any help greatly apprecaited Thanks Suzanne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reading from CSV date format
there arre two solutions.
1) Make the cells in excel text before importing the CSV 2) Importing CSV allow you to select cell formats. In Import menu - select file a) first window use default delimited b) second window uncheck tab and select comma c) third window allos you to select formating. "Grd" wrote: Hi there, When I read from my CSV file the date column is in DD MM YY - its a string in the CSV file (with quotes). However when it comes into excel is MM DD YY. How do I stop this conversion from happening automatically. Any help greatly apprecaited Thanks Suzanne |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reading from CSV date format
Thanks
I'll try those out "Joel" wrote: there arre two solutions. 1) Make the cells in excel text before importing the CSV 2) Importing CSV allow you to select cell formats. In Import menu - select file a) first window use default delimited b) second window uncheck tab and select comma c) third window allos you to select formating. "Grd" wrote: Hi there, When I read from my CSV file the date column is in DD MM YY - its a string in the CSV file (with quotes). However when it comes into excel is MM DD YY. How do I stop this conversion from happening automatically. Any help greatly apprecaited Thanks Suzanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not reading date format | Excel Discussion (Misc queries) | |||
| Cell format on reading .csv file | Excel Discussion (Misc queries) | |||
| Copnvert dates reading as Text to a date format | Excel Discussion (Misc queries) | |||
| Reading Wordpad - Rich Text Format | Excel Programming | |||
| Reading conditional format that is active in VB | Excel Programming | |||
Hybrid Mode
