Sorting values with currency symbol sort by symbol rather than amount
Sorting values with currency symbol sort by symbol rather than amount

I have various values in a column, for example:
£200
$50
€500
£60
£40
But instead of sorting by number value, it sorts by currency symbol like this:
£200
£60
£40
$50
€500
Is there a way around this?
You can see it in action in the middle of the page here:
bigfreebet dot com.
£200
$50
€500
£60
£40
But instead of sorting by number value, it sorts by currency symbol like this:
£200
£60
£40
$50
€500
Is there a way around this?
You can see it in action in the middle of the page here:
bigfreebet dot com.
This discussion has been closed.
Replies
Allan
Allan