change Balance sheet amounts to different currency

[richiwatts]

I have 3 Balance Sheets fro my company and I need to convert all the figurs from GBP to USD

So I need all the figures to be multiplied by 1.5834

What is the quickest way to do this?

Rich

 

[Robert Mika]

See below:
Sheet1

Excel Workbook
	A	B	C
2	Before
3	1
4	2
5	3		1.5834
6	4
7	5
8	6
9	7
10	8
11	9
Sheet1

Excel Workbook
	A	B	C
2	After
3	1.5834
4	3.1668
5	4.7502		1.5834
6	6.3336
7	7.917
8	9.5004
9	11.0838
10	12.6672
11	14.2506
Sheet1

Put 1.5834 into any cell then copy,Paste Special-Multiply

 

[richiwatts]

Thanks, but what happens if I need to update the exchange rate?