N
ncprius
Running Office 2007. How can I get (or format) dates from the 1700s through
2010 to sort? It sorts dates ascendingly from the 1900 and 2000s just fine
but throws the 1700/1800 dates at the bottom and then not in any particular
order.
I've already tried formatting dates as almost every choice in the date
format window and I've tried typing dates as 1/23/1899, January 23, 1899,
etc. but nothing sorts correctly (ascending or descending).
Thanks for any help you can give me.
2010 to sort? It sorts dates ascendingly from the 1900 and 2000s just fine
but throws the 1700/1800 dates at the bottom and then not in any particular
order.
I've already tried formatting dates as almost every choice in the date
format window and I've tried typing dates as 1/23/1899, January 23, 1899,
etc. but nothing sorts correctly (ascending or descending).
Thanks for any help you can give me.