Universal currency cell conversion

  • Thread starter Thread starter Phil Yates
  • Start date Start date
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
 
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
 
Back
Top