Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've imported some MYOB general ledger reports into Excel, but have found
that Excel 2003 reads dates in the first 12 days of the month as MM/DD/YYYY (USA format) when they are actually DD/MM/YYYY (i.e. European / Austalian / NZ format), even though i have correctly set my Windows Regional settings to Australia (i.e. DD/MM/YYYY). Am really sick of having to scan sometimes 200 lines to fix these dates - very annoying. Excel 2000 doesn't make this boo-boo ! Is anyone at MS working on this URGENT problem ??? Have also reported this issue to MYOB Support in Melbourne. Kym Yeoward Alice Springs NT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
How do I convert Excel 2003 to Excel 98 format? | New Users to Excel | |||
Excel 2003 is changing my date formats | Excel Worksheet Functions | |||
Excel Date Format - Stop? | Excel Worksheet Functions |