Hi,
Thank you for your continued help and support. Appreciate it.
I am stuck with custom sorting. I have a column which displays notional values as USD 100,234,459. I want to sort this based on just the number. i.e. if I have AUD 90,000,000 and USD 1,000,000. then USD 1,000,000 should appear before AUD 90,000,000 if sorted in ascending.
Any help is much appreciated.
Cheers
Inder