Cells are not sorting correctly
 

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!

Cells are not sorting correctly
 

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

On Dec 17, 7:19*pm, Daze3Daze
wrote:
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!

Cells are not sorting correctly
 

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

"Pete_UK" wrote:

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

On Dec 17, 7:19 pm, Daze3Daze
wrote:
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!