Universal currency cell conversion

P

Phil Yates

I need to convert a worksheet valued in Euro, to
Australian and Singapore Dollars. How can I do this in a
simpler way than taking the time to convert each cell?

Thanks in anticipation
 
J

Jan Karel Pieterse

Hi,

- Find an empty cell and enter the conversion rate into it.
- select all cells which need conversion
- choose Edit, paste special, values, multiply.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Top