I have a data base in Excel on A Mac with one column listing dates.
I need to sort the data into date order but some of the date entries appear
not to be treated as dates.
The format tab indicates that all the entries ARE dates, but if I do a
DATEVALUE() on the range, some convert to numbers but others to "VALUE".
Even if I re-enter the dates manually, they still do not sort porperly.
Anyone able to help please?
Bookmarks