View Single Post
  #1   Report Post  
KymY
 
Posts: n/a
Default Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form.

Have recently upgraded to a new XP Pro PC with Office 2003

However when exportng accounting reports from MYOB Premier 8, I now find
that Excel treats the MYOB dd/mm/yyyy format dates (Australian format) as
mm/dd/yyyy (US format)

My Win XP Region setting is Australia and my Language setting is English
(Australian)

How can I adjust the Excel Options to ensure the defualt date format for new
Excel sheets is dd/mm/yyyy ? (there's nothing on this in the International
tab)

Kym Yeoward
Alice Springs NT
Australia