| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening CSV, How to Tell Excel String is not a Date?
In a CSV file I have values like "3-1". Excel interprets this as a date:
3/1/05. What encoding can I use in my CSV files to force Excel to read it as a literal string? I have already tried double quotes around the string. I am using Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep Excel from opening new instance | Excel Discussion (Misc queries) | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
| Excel file modification date | Excel Discussion (Misc queries) | |||
Threaded Mode
