Hello,
I have a column titled "RANGE". The ranges of money are $0-$999, $1,000-$4,999, $5,000-$9,999, $10,000-$14,999, $15,000-$19,999, and $20,000+
However when Excel lists these it has the $5,000-$9,999 range listed last. How can I get that range to its proper spot?
Thank you
It's being sorted as text, not currency. You'd need to put in leading zeroes to align the digits. Or split lower and upper values into separate columns. Then sort on the lower column.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you for your response. So there is no way that i can get that range in its proper spot? There is no way for excel to detect it as currency?
It's not currency. Currency is simply a numeric value with a format applied.
You have a text string that contains a couple of dollar signs, a hyphen, some commas, and some numbers ... two sets of numbers. However, the combination means it is a text string and that's the way it gets sorted.
If you need it for user presentation, you would be better splitting the values to allow you to deal with them as numbers and then using concatenation to combine them.
Note that, as it stands, the numbers are useless other than for visual presentation. Not only can you not sort them, you can't do any numeric calculations or comparison. You can't say, is this number in that range?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks