| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date sort problems
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) | |||
Threaded Mode
