| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Dates when there are zeros in the month and/or day
I need to sort a column of date values that contain valid dates (i.e.
12/12/1990) as well as dates that contain zeros in the month and or in the day (i.e. 01/00/1990 and 00/01/1990). I have managed to blend the missing day dates into the range using mm/yyyy as my format, but I can not get the dates with the missing months to incorporate. Any tips? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping leading zeros in imported data (one digit month as 05) | Excel Discussion (Misc queries) | |||
| Sorting zeros | Excel Discussion (Misc queries) | |||
| Sorting dates by month instead of year | Excel Worksheet Functions | |||
| Custom sorting with Letters and Zeros | Excel Discussion (Misc queries) | |||
| Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
Threaded Mode
