MrExcel Publishing
Your One Stop for Excel Tips & Solutions

EURO


Posted by Ashmore on January 04, 2002 5:42 AM

How can I convert a spreadsheet from German Marks to Euro without calculating each amount?


Posted by IML on January 04, 2002 6:00 AM

This may work, be sure to have a back in case
Put the exchange rate in a cell and copy it.
Highlight the whole sheet, right click and select paste special. Choose multiply under the operation section.

Good luck

Posted by Ashmore on January 04, 2002 8:03 AM

Thanks a million! It worked!