View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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