Cells are not sorting correctly

D

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!
 
P

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
 
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top