US/Canadian conversion

[barhumph]

I have make up a budget and now need to convert all the numbers from
Canadian currency to US currency. How do I do this? I have 3 worksheets
that need to be done. Can they be done by columms or do they need to be
done by each individual cell?

Thank you in advance,
Barb

 

[JE McGimpsey]

I have make up a budget and now need to convert all the numbers from
Canadian currency to US currency. How do I do this? I have 3 worksheets
that need to be done. Can they be done by columms or do they need to be
done by each individual cell?

Thank you in advance,
Barb

One way:

Enter your conversion factor (0.7429 as of 1800Z today) in an empty cell.
Copy the cell. Select the cells to be converted. Choose Edit/Paste
Special, selecting the Values and Multiply radio buttons.