Cells are not sorting correctly

[Daze3Daze]

Hi...I'm trying to sort a column of percentages from highest to lowest
I unhide and highlight all the columns (so they stay together) and then hit
Data/Sort/Descending
and then choose the column I want to sort
Problem is that the column is not sorting in any kind of order
I make sure that the column I'm trying to sort are all formatted as
percentages....I can't figure out why they're not sorting correctly
Oh...and if I try to sort in ascending order...same problem...they don't
sort correctly
It's as if it just mixed up the rows in some random order
Hope someone here can help me!!!

Thanks!

 

[Pete_UK]

Are your percentage values proper numbers, or are they text values
that just look like numbers? Or do you have a mixture of both?
Formatting will not change the values. Highlight the column and click
on the Increase decimal places icon a few times - proper numbers will
respond, but text values will not.

Hope this helps.

Pete

 

[Daze3Daze]

I did make sure all the formatting was the same before I sorted. I did try
your suggestion though of increasing the decimal places...They all changed

Any other suggestions??