Current rates are 1.16 cdn to 1 us.

us * 1.16 = cdn

Enter 1.16 in an empty cell.

Copy that.

Select column with us prices and Paste SpecialMultiplyOKEsc.

Clear the cell with 1.16.


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 19:45:02 -0800, "suegr"
wrote:

I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.