| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem custom sorting a date in an excel file
I have an Access report that is output to an excel file. I open the excel
file and do a data create list so I can do a custom sort. The field I am trying to sort is a date field it is formatted "16-Jan-2009". I select custom and contains and type in "Jan" and click OK. I get no sort at all, it comes up blank. I have tried formatting the date 2 ways and it still comes up blank. What am I doing wrong? -- clcnewtoaccess |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date format problem from opening dbf file in excel 2007 | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Problem with sorting by date columns | Excel Discussion (Misc queries) | |||
| problem with date sorting | Excel Worksheet Functions | |||
| Date sorting problem | Excel Discussion (Misc queries) | |||
Threaded Mode
