Hi,

Having trouble with date formats. In excel 97.

have exported a list of dates from Access 97 which are in the format dd/mm/yy. I get them into Excel and try format them to be in the format 04-Mar-05 so that I can sort them.

Problem is that any date that has been exported from the database will not change to this format. I select the new format and it takes, but the actual data on screen does not change.
I can enter in new dates and format them fine.

Any suggestions?