| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop Excel reading 01/02 as 1st February 2007
I know that you can stop it when entering data by using a ' before the data,
but I have exported data as a csv from Access and want to read it in Excel; yet every time I open the csv it converts the available years (i.e. it ignores 00/01, but converts 01/02, 02/03 etc) to dates. Is there a box somewhere in 'options' that I have to tick/untick? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Excel 2007 from Changing Column Widths | Excel Discussion (Misc queries) | |||
| No ActiveX controls when reading 2007 file formats into Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I stop graphs reading zero in Excel from cells with ""? | Charts and Charting in Excel | |||
| How do I stop graphs reading zero in Excel from cells with ""? | Excel Worksheet Functions | |||
| reading blank cell as active - how can I stop it ? | Excel Discussion (Misc queries) | |||
Threaded Mode
