View Single Post
  #1   Report Post  
KymY
 
Posts: n/a
Default Excel 2003 Trashes Imported Dates

My local date in Windows/Reional & Language options is DD/MM/YYYY

So how come Excel 2003 trashes dates imported from MYOB Accounting for the
1st to the 12th of each month, and treats my MYOB DD/MM/YYYY dates as if they
were MM/DD/YYYY ??

Can someone get the folks (clowns ?) at MS to FIX this problem A.S.A.P.
please ??
Is there a work-around / script to fix this ?

Am getting thoroughly sick of having to manually fix the dates in ledger
reports exported to Excel 2003. (This problem doesn't occur in Excel 2000)


Alice Springs NT Australia
27/04/2005