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?
Bookmarks