Asked this on the EU forums, but TBH I think I'm more likely to get a good answer here... and no it isn't addon related.
Trying to create a good looking spreadsheet to record my many alts.
I want to list how much gold.silver.copper each has.
While I can easily do:
1g 50s 50c or 1.50.50
Excel sees that as a Text value and I can't perform calculations on it.
Is what I currently do but it doesn't look right and I can't seem to force a comma at the hundred mark, it will only show at the thousand mark instead.
Does anyone know of either a method to show WoW money in its native form eg 1g 50s 50c or a way to force Excel to add a comma at the hundred silver mark? Either method should allow for calculations to be done on the data, and sort properly eg 1g 50s 50c is lower than 2g...