Just a guess....

I don't think it has anything to do with any of your templates.

I'm guessing that when you imported your data from MYOB, the data that looked
like valid dates changed to dates--but the ones that don't look like dates,
didn't get changed and were brought in as text.

If one of your dates looks like:
01/02/03
in MYOB (I don't use it)

Check to see if that date still represents the same date in Excel.

Format that date in a non-ambiguous format: mmmm dd, yyyy and see if you really
got:
January 02, 2003
or
February 03, 2001
or what.

If all your "Dates" imported from MYOB can be brought in as text, you'll be
better off. You'll be able to select that column of dates and do:

data|text to columns
choose the correct date format (ymd, dmy, mdy,...)
and it should work.

I don't know if MYOB works that way, though--but I wouldn't trust the dates --
especially if some were converted to dates and some weren't.

======
Excel's template file for new workbooks/worksheets is buried into the program
(and some registry settings). But you can override those defaults by creating a
book.xlt (or sheet.xlt) and storing it in your XLStart folder.)


Doug McKean wrote:

Where is the default excel (office 2003) template located? I suspect I
have somehow modified mine.

I have a problem exporting a report from MYOB into excel in that the
date appears in the US format for the first 56 rows, and then the
Australian format for the remaining rows. I have all settings as far as
I can see in the computer set to Australian format. Even when I try and
change the date format to Australian on the first 57 rows the display
will not change to Australian format. I have tried clearing all formats
and reformatting it but it still will not change (in these first 57
rows). The problem seems to be confined to my computer as I have tested
other computers in our office without any problems.

--

Dave Peterson