C
chalky
I have an issue with a pivot table - i currently have month date
running along the top of a spreadsheet and this has always sorte
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 Januar
and February. I have put the dates into number format to check they ar
correct and 31 March 2006 is definetely coming up with a higher numbe
than the February or January ones.
The other years which are still on the sheet are still sorte
correctly.
Any ideas? If it isnt just a style thing it is also important for
calculation that is being run on it.
thank
running along the top of a spreadsheet and this has always sorte
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 Januar
and February. I have put the dates into number format to check they ar
correct and 31 March 2006 is definetely coming up with a higher numbe
than the February or January ones.
The other years which are still on the sheet are still sorte
correctly.
Any ideas? If it isnt just a style thing it is also important for
calculation that is being run on it.
thank