Forum Discussion
Sorting in Pivot Table
When trying to sort my "Conc" column from highest to lowest, Excel is doing so by the first digit and not the actual value (see the highlighted values in the picture)
How can I get it to sort it by actual value (ie 2000, 1000, 500, 250...etc)?
My guess Conc are texts (since they are left aligned). Is that by design or you could convert values to numbers?
6 Replies
My guess Conc are texts (since they are left aligned). Is that by design or you could convert values to numbers?
- They are formatted as numbers throughout the whole workbook...
It doesn't matter how they are formatted. If you format text as number it still be the text. You may try in any empty cell =ISTEXT() on any cell with Con, is it return TRUE or FALSE.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
