I have an issue with a pivot table - i currently have month dates
running along the top of a spreadsheet and this has always sorted
correctly from earliest date on the left to latest on the right.
However now we are in 2006 it is sorting March 31st before both January
and February. I have put the dates into number format to check they are
correct and 31 March 2006 is definetely coming up with a higher number
than the February or January ones.

The other years which are still on the sheet are still sorted
correctly.

Any ideas? If it isnt just a style thing it is also important for a
calculation that is being run on it.

thanks


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=534549