When I switched from Mac to PC some years ago, I had trouble with dates
created on a Mac because it uses the 1904 date system, while PCs use the
1900 system and some dates were four years off. Check the setting in
Tools-Options-Calculation.

"Graham_Wright" wrote in message
...
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?