Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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" wrote in message ... 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
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |