Excel - cannot sort large-to-small

[DaddyTorgo]

I have a spreadsheet I'm trying to sort. The first time I did it, it worked fine...I sorted by column a (text) and then by column b (numbers).

I opened a new instance of excel and created a test sheet and i can sort largest to smallest again, but if I go back and re-export the data for the first sheet I still can't.

I literally have them open side-by-side and I can't sort the data i exported out of salesforce. which is weird, as i've always been able to in the past...

WTF

[Rizon]

Maybe it's not recognizing it as numbers? Check cell formatting?

[Coffee Warlord]

S'what I was thinking. Maybe you need to reset that columns to a numeric type or something.

[DaddyTorgo]

Already tried that - first thing I thought of too. It's not that.

And in the second instance of excel i have open it sorted it perfectly fine - first column numbers, second column text. And both options were there in the sort dropdowns.

Even when I select just that one column it won't give me the option to sort largest-to-smallest.

Fucking Excel.

[DaddyTorgo]

Weird...I just exported one report from Salesforce to excel in regular format (not "printable view" format which my partner prefers) and made sure that its column was in numbers and could sort it largest-to-smallest fine, but when I export in "printable view" I can't sort largest-to-smallest even after making sure the column is in number format, and selecting only the values that are there (not the header line).

Aaaah - figured it out. Apparently it's picking up the "-" that Salesforce populates for an empty field and that's kicking it back from thinking it's a number.

WOOHOO...NOT CRAZY. PROBLEM-SOLVER!

[Suburban Rhythm]

Where are you sorting from?

There is the 'Sort & Filter' button to the far right of the home tab. That's crap, don't use it. I've seen goofy issues with that before.

Choose Sort under the Data tab

Also, when you say you are exporting from salesforce, any possibility it is creating a table with the data, rather than just plotting into the sheet?

[DaddyTorgo]

Funny - i don't feel like it's ever picked up the " - " before this and kicked it back. wicked weird.

[CU Tiger]

the newest edition of excel has thrown me a few curves lately as well.
It appears to have some under the hood formatting functions we cant see/edit. I cant think of an exact example, but Ive see the exact ssame behavior you are describing.

[M GO BLUE!!!]

Did you create a spreadsheet of the women that you are writing to online & trying to sort by weight? :D