Ask Your Question

Sorting by Dollar values.

asked 2017-06-07 17:53:55 +0200

hank gravatar image

When I sort my data by "Price" column, I get results grouped by $1's, $10', and $100 so on are grouped together. Is there any way I can sort by price and sorted by dollar values?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-06-07 18:40:24 +0200

hank gravatar image

I figure it out by trial and error that check the Other options/Detect special number box in the Text Import drop page will do the job.

edit flag offensive delete link more

answered 2017-06-07 18:23:06 +0200

komma4 gravatar image

Sound like you have text, not (formatted) values. You should see it, as text (normally) aligns left, values to the right.

If so: do a Search (for the $ sign), replace with nothing (leave empty). This will change the text into values.

Next create a cell style for your currency display and assign it to the cells. Now sorting will work.

edit flag offensive delete link more


Thank you! I will try this as well!

hank gravatar imagehank ( 2017-06-07 18:42:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-07 17:53:55 +0200

Seen: 106 times

Last updated: Jun 07 '17