Numbers behave like text in pivot table

[yabi100]

I formatted row labels (see image below) as number in original table and checked with isnumber. However here in pivot table they behave like text. I want to sort them descending.

 

[RoryA]

Looking at that you must have a mix of numbers and text in your source data, since that is clearly numbers sorting first then text (you can tell because you have numbers repeating).

 

[yabi100]

Thanks for your reply. I check whole column with isnumber command and result for all cells is: true. But when I sort that column in pivot table, it appears like that.

 

[RoryA]

I'd have to see the workbook then, because the sorting and grouping you have there only makes sense for a mixture of text and numbers. Can you put the workbook on a sharing site like OneDrive or Dropbox?