How do I multiply the whole sheet by a number

[Ed1939]

I have budgeted in US$ instead of the local currency. Now, do to the dollar
drop, y have to change the budget and would like to multiply the sheets by
one factor.
I use Office xp

[Andy Wiggins]

Here's a way to perform currency conversions:
http://www.bygsoftware.com/Excel/Int...conversion.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Ed1939" <Ed1939@discussions.microsoft.com> wrote in message
news:612AF4C5-A028-45E3-9A4D-2001C41C5BAF@microsoft.com...
> I have budgeted in US$ instead of the local currency. Now, do to the
dollar
> drop, y have to change the budget and would like to multiply the sheets by
> one factor.
> I use Office xp

[Earl Kiosterud]

Ed,

If you want to make a permanent converson of the values in the cell, put the
multiplier in a cell, and Copy. Now select the cells to be converted and
Paste Special - Multiply.

It seems, however, that if you've done the budget in USD, you'd want to have
a separate column with the converted values (per the current rate to local)
with a simple formula.
--
Earl Kiosterud
www.smokeylake.com

"Ed1939" <Ed1939@discussions.microsoft.com> wrote in message
news:612AF4C5-A028-45E3-9A4D-2001C41C5BAF@microsoft.com...
>I have budgeted in US$ instead of the local currency. Now, do to the dollar
> drop, y have to change the budget and would like to multiply the sheets by
> one factor.
> I use Office xp