Currency Exchange

[Safequip]

I need to format an american price list into £ using exchange rate, can anyone help?

 

[ThrottleWorks]

I might be able to asist.

Do you want to derive data from net or the data is already ready and you want process it further ?

Could you please explain your problem in more details.
Have prepared a macro for populating exchange rates for self use.

 

[Safequip]

Hi thanks for your speedy response I need to convert a full spreadsheet from dollar to £ using the exchange rate of 1.64 so for example $34.20 would then be £20.85 hope this makes sense

 

[ThrottleWorks]

Hi Safequip, is it possible for you to upload a sample workbook.
You mean the exchange rate will be static, no need to derive it from net ?

Please correct if wrong. Can we use a simple formula "=A1/1.64" to get the results.
Without sample data it is tad difficult to progress.

Or if we go by VBA then Range("A1").value = Range("A1").value/1.64

 

[Safequip]

simple formual has worked don't know why I didnt think of that before, thanks for your help Throttleworks xx

 

[ThrottleWorks]

Thanks for the feedback, glad you solved it.

Please keep contributing with questions, answers, doubts and ideas.