Date in data imported from MYOB to Excel 2003

M

Manly

When sending a report from MYOB (Version 13) to Excel 2003 the date in the
Excel spreadsheet is incorrect. This problem did not occur in Excel 2000.
Some dates in the Excel report show as MM/DD/YYYY (Regional Settings are
DD/MM/YYYY) and others it changes to text.

Reformatting the dates in Excel 2003 does not fix the problem as the numeric
value of MM/DD/YYYY is there for some and the others are text and not dates.
ie the data is inaccurate by the time it is shown in the Excel 2003 report.

Is there something I can do to solve this annoying problem? I would really
appreciate assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

International Date formatting 6
Publisher is filling blank lines with data 2
Convert 24/03/2010 date into 03/24/2010 date format 3
Date formatting 1
UpperCase changes date format 1
Date Format 10
Different Date formats in text to be recognised as date value 8
Date format error with CSV file 6

Top