When I select paste special it just shows Unicode text or regular text.....
It makes sense but doesn't work with this office 2000...

"Gord Dibben" wrote:

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.