Forum Discussion
Solved
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...
My guess Conc are texts (since they are left aligned). Is that by design or you could convert values to numbers?
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.
- Yup, that's the problem. Thank you so much!
