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?
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.
Thank you! I will try this as well!
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.