ExcelBanter - Convert currency of the whole worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert currency of the whole worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/71373-convert-currency-whole-worksheet.html)

Convert currency of the whole worksheet

I have budget worksheets in HKD and I would like to convert them into USD to
work on. Is there a easy way to convert all the worksheets into USD instead
of using the formula in each columns?

Sloth

Convert currency of the whole worksheet

you can copy the currency rate and paste special selecting multiply.

"PH" wrote:

I have budget worksheets in HKD and I would like to convert them into USD to
work on. Is there a easy way to convert all the worksheets into USD instead
of using the formula in each columns?

All times are GMT +1. The time now is 11:13 AM.