On Wed, 27 Apr 2005 02:52:06 -0700, "KymY"
wrote:

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



Hmmm. It seems as if you posted this same problem this past February. If that
was you, what happened when you tried the suggestions given you at that time?

It'll be hard to devise a work around without that information.

It is likely a problem with the manner in which MYOB exports its data, and, if
that is the case, you should direct your complaints to MYOB to export their
data in accord with the computer's regional settings.

Several workarounds come to mind depending on how MYOB does it's export.

1. If the data is in a csv file, change it to a txt file before import. Then,
when you do the import, excel will show a text import wizard which will allow
you to specify the dmy order.

2. Temporarily change your regional settings to match the MYOB export format.


--ron