| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format in Excel 2002
I have an application that downloads data to an Excel file, including a
column that is supposed to contain dates in mm/dd/yy format. It works well in Excel 2000 and Excel 2003. But in Excel 2002, the data is completely messed up - some are converted to dd/mm/yy format, some remain as text format. So when I sort by that column, my sort is likewise messed up. Is there a default value in Option-Tools in Excel 2002 that's making this happen? One common pattern I notice is that - it becomes a problem for dd values that are less than 12, which probably means Excel 2002 is un-certain whether it is a day or a month. Anyone experience similar problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel 2002 - Date format keeps changing | Excel Discussion (Misc queries) | |||
| How do I save an excel spreadsheet in pdf format (Office 2002) | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Threaded Mode
