All sorted.... but hard to check.

When it was pointed out that the metric used was inaccurate and we shouldn't have been

hit with the extra 4% FVF eBay, credited the fees but checking it was a nightmare.

You can download account activity as a CSV file but the dollar amounts are in AUD$ format

( eg AUD$ 0.45 ) which can't be sorted in Excel.

Just wondering if anyone knows an easy way to convert AUD$ 0.45 to $0.45

Currently I have to create a new 'currency formatted' column and manually add the figures.

_________________________________________________________________________________________________

Cosmologically speaking we are all little more than a bacterial film on a soft rock hurtling through an unimaginable void.
Don't take it all too seriously.