Excel filter sorting is not working

[yxz152830]

Gurus,
I have the 'highlight duplicate' enabled so I know these highlighted ones have duplicates but they do not get sorted together. What is the most likely reason for this? Thank you!

 

[awoohaw]

are all cells the same datatype? Numbers sort differently from text.

To confirm take off cell justification, and change to NUMBER with some Decimals.
Also, do you have any zero length text characters in front of the text? Is it part of a table that had other sorting that you need to remove all sorts?

If it is a formula sort, what is the formula (and data the formula is based on)?

 

[yxz152830]

are all cells the same datatype? Numbers sort differently from text.

To confirm take off cell justification, and change to NUMBER with some Decimals.
Also, do you have any zero length text characters in front of the text? Is it part of a table that had other sorting that you need to remove all sorts?

If it is a formula sort, what is the formula (and data the formula is based on)?

Hi Gurus thanks for noticing. Yes the values were in different datatype I think. After I double clicked on it and entered, it got sorted. So here I have another question. How do I mass change the datatype without having to click on each one and then hit enter to really convert it to text?

 

[awoohaw]

Try this:
It works for me most of the time:
Highlight to range of cells (or click entire row/column).
Set format to TEXT.
Then: (can only be done in columns or portions of a column): On Data Tab, use the text to columns feature step through the process and choose text. Click OK.
(if you have apostrophe's before numbers they may remain, but should not affect the sort).