i have a whole pricelist that needs to be converted from euros into
australian dollars,
the formula would be: <the number*1.63 how do i quikly convert this??
Enter 1.63 in a free cell & copy it.
Select the range of cells to be converted & Edit -- Paste Special --
Multiply -- OK.
Rgds,
Andy
|