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