How To Format Multiple Currencies

Spreadsheets,Tips 15 March 2011 0 Comments

We’ve already shown you how to convert between different currencies in a spreadsheet. But how do we format the resulting figures such that 100 US dollars is shown as $100 and 100 British pounds is shown as £100? Google docs spreadsheets allows you to set a global setting for the currency, and then override that [...]

Tagged in , , , , , , , , ,