| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort imported date column
I exported a CSV file from one of my on-line accounts. The file has a list
of names, account numbers, and dates. Although the cells containing dates are formatted as dates in the Format Cells-Number-Date, the sorting function does not recognize that and will not sort oldest to newest. If I manually retype a few of the dates into another column, Excel recognizes those as being dates with no trouble. Is there something about importing from a CSV that would cause this behavior? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rec'd imported "date,value" in one column how do I separate? | Excel Discussion (Misc queries) | |||
| how to sort a column containing date of birth? | Excel Discussion (Misc queries) | |||
| Keeping Imported Picture in Cell During Sort | Excel Discussion (Misc queries) | |||
| Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
| sort column in date order dd/mm/yy | Excel Discussion (Misc queries) | |||
Threaded Mode
