| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Excel changing CSV text into dates
My application generates CSV data files. Users view these in Excel.
When a row of the CSV file contains the text 1-1, Excel incorrectly renders it as a date (1 January). If users then format the cell as text, they don't get 1-1 back but a useless number (the Excel numerical representation of 1 January). How can Excel be made to open a CSV file (when the user launches that file from Explorer) without screwing with it? It just needs to display the text in the file and not try to "format" it. I could not find any suitable setting in ToolsOptions, nor does placing various sets of quotes around the 1-1 appear to have any effect. Eq. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to stop fractions in a columm automatically changing to dates | Excel Discussion (Misc queries) | |||
| stop fractions changing to dates | Excel Discussion (Misc queries) | |||
| Stop UK-style dates changing to US-style dates when mailmerging. | Excel Discussion (Misc queries) | |||
| How to stop text changing to date | Excel Discussion (Misc queries) | |||
| Stop Excel from changing numbers to dates in CSV file | Excel Discussion (Misc queries) | |||
Threaded Mode
