# How do I multiply the whole sheet by a number

1. ## How do I multiply the whole sheet by a number

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

2. ## Re: How do I multiply the whole sheet by a number

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

3. ## Re: How do I multiply the whole sheet by a number

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1