There's a cleaner way to do it with Array Formulas, so you don't need to keep extending it.https://www.benlcollins.com/formula-examples/array-formulas-forms/

Is there a way to sort numbers correctly if the field isn't just numbers? For instance, I want the following to be sorted largest to smallest:100s5000+34Bonus points if they can still be used in calculations - I'm mainly looking to total them. Of course it won't be exact, but 5164 would be acceptable.

You can probably use regexextract to extract just the numerical digits, in a formula in a separate column. Then sort by and total the second column.You can do regexextract in google sheets or with an excel addon

Found the solution here: https://www.extendoffice.com/documents/excel/4264-excel-display-different-text-than-value.htmlBasically I'm inputting 5000 but the cell is displaying 5000+. Slightly convoluted, but it works.Now let's see if I can get it to work in Google Docs as well .

So you want them all to display a + after the number?

Not all, only a few. Few enough that this process won't be that much of a pain.

#,#+

So how does Excel know which ones to add it to? Are you only applying the conditional formatting to those cells?

You can do it in google sheets by applying a number format. Select the cell(s) you want, click Format > Number > More Formats > Custom Number Format. Enter this for the format:Code: [Select]#,#+(won't work if you have decimals, we'll have to tweak it then)

Correct.Awesome, thanks!Worked great for 5000+ (I don't need decimals here), but isn't working for 100s. I suppose I could instead use 100+, 200+, etc. if needed.

Funny that it's not working for the 100, 200... it works for me. What's it showing you?

It says invalid format as soon as I add the s.

Ah, I see. Try putting the s in quotes