Excel Date Sort Issue on Mac

Hey all,

I have an interesting issue. We have information in an Access database ('03 version).....this information is exported to Excel ('03 version) where it is viewed and manipulated. In the date field, we use the format DDMMYYYY. On a PC, this works out just fine...the dates can be sorted properly. On a Mac however, it seems to be treating the same date field as text...so the sort might display 2Feb2007 before 3Jan2007 because 2 comes before 3....ignoring the rest of the date. The Mac user can take an extra step and change the format to "date" manually but for some reason they must click on each cell.....they can't do it by column.

SO....the questions for the experts out there:

1. Is there some type of glitch that occurs when these types of files are sent from PC to MAC that makes this happen?

AND

2. Is there anything that can be done at any stage to prevent it? (For example changing the way the variables are concatenated in Access, etc.)

Thanks for your input!

Probably the wrong forum for your question

|||I had a hard time finding a good place for it. Do you know if a forum on here that covers this kind of stuff?

Thanks!|||

Hi,

I don't actually, but you could try

http://www.microsoft.com/mac/community/community.aspx?pid=community

that did take me to

http://groups.google.com/group/microsoft.public.mac.office/topics

or have a look in some of the Mac forums. Not being a Mac user I can't advise you the best place to go for that.

Good luck

Matt