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?
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?