Jose,
Depends. Translating foreign currencies can be difficult.
Here is a link that might be a good launching point.
http://acct.tamu.edu/smith/fctrans.htm
In addition, you might wish to investigate on the web more sources. Good
search words for using Google are: "accounting translation foreign currency
temporal" (without the quotes).
A key sentence is as follows: "There are basically three approaches to
currency translation: (1) temporal rate method, (2) current rate method,
and (3) use of both methods. "
If you are projecting into the future, you get in trouble once again because
of anticipated FX movements, hedges, and different discount and interest
rates and the like.
BUT, if you simply want to show $US, regardless of the previous issues, then
I suggest the following:
1) Make a back-up of your spreadsheet, or duplicate the particular sheet in
the book
2) Enter into a blank cell the FX rate you want to use
3) Copy FX
4) Select the cells you want converted from pesos to US$
5) Edit | Paste Special...check formula and multiply or divide (depending on
how you inputted the FX rate)
Hope that gives you some food for thought.
Regards,
Kevin
jose said:
I'm working on different spreadsheets overseas with pesos instead of u$s.
Of course they contain lots of formulas in their cells. I wonder if there is
any way to take any spreadsheet made in pesos ( with a different exchange
rate ) and show its results in dollars instead.
