View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How to convert Euro's to Canadian dollars?

Put your Euros in A1, in B1 put 1.41177, in C1 put

=ROUND(A1*B1,2)

format as currency, that's your Canadian dollars


http://www.xe.com/ucc/convert.cgi

go there to get the current rates

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Car" wrote in message
...
I have a budget in Euro's which needs to be transposed to Canadian
dollars -
the Euro conversion table does not give me the 'to' option of selecting
Canadian dollars.