G
Gerry
I got some advice before but I am still having problems sorting dates. Using
Excel 2003. I have a file of about 1000 records over a time span of 1750 to
1921.
When I sort by what I think is the date the order result is as follows...
1900 to 1921
followed by 1750 to 1899.
I can fix by moving a set of records to the bottom but that doesn't help if
the sort parameter is not the primary one.
Can I convert the date column to anything else to solve my problem.
I am not terribly interested in time between dates etc..
Thanks
Slán
Gerry
Excel 2003. I have a file of about 1000 records over a time span of 1750 to
1921.
When I sort by what I think is the date the order result is as follows...
1900 to 1921
followed by 1750 to 1899.
I can fix by moving a set of records to the bottom but that doesn't help if
the sort parameter is not the primary one.
Can I convert the date column to anything else to solve my problem.
I am not terribly interested in time between dates etc..
Thanks
Slán
Gerry