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 , , , , , , , , ,

How To Calculate Foreign Exchange

Spreadsheets,Tips 9 March 2011 6 Comments

Gone are the days or keying in and manually updating an exchange rate in a cell of a spreadsheet and using that to perform currency conversions. Many of the formulas and functions available in Google docs spreadsheets are plugged into the real time web. Currency conversion calculations can always be up to date without having [...]

Tagged in , , , , , ,