Page 1 of 1
[Solved] Currency Convert Entire Calc Document
Posted: Thu Mar 28, 2013 3:55 pm
by Alabandit
Hi
I have a complex document that is currently in Dollars and need to convert it to Euro's. Is there a simple way to do this?
Alternatively the document has a few base fields that I can convert manually and all the formula will correct to Euro equivalents. e.g. Item valued at $1000 is now €781.34.
But this still need me to adjust 100 of columns. Is there an easy way to do this with out changing all cell values of months, for instance, to have having a Euro symbol?
Thanks for you help!
Re: Currency Convert Entire Calc Document
Posted: Fri Mar 29, 2013 1:59 pm
by jrkrideau
Alabandit wrote:Hi
I have a complex document that is currently in Dollars and need to convert it to Euro's. Is there a simple way to do this?
Alternatively the document has a few base fields that I can convert manually and all the formula will correct to Euro equivalents. e.g. Item valued at $1000 is now €781.34.
But this still need me to adjust 100 of columns. Is there an easy way to do this with out changing all cell values of months, for instance, to have having a Euro symbol?
Thanks for you help!
Any way that you can supply a working example? The question is a bit too broad for an easy answer without seeing the data? You can attach a small example here or, if the file is too large, you can post it at someplace such as
MediaFire for other forum readers to examine.
Re: Currency Convert Entire Calc Document
Posted: Tue Apr 02, 2013 11:30 am
by Alabandit
I have attached a simple example, the first table is my table in Dollars. The second table is in euro's but I can't get it to switch the format to euro's automatically.
Thanks for the help
Re: Currency Convert Entire Calc Document
Posted: Tue Apr 02, 2013 3:03 pm
by jrkrideau
Alabandit wrote:I have attached a simple example, the first table is my table in Dollars. The second table is in euro's but I can't get it to switch the format to euro's automatically.
Thanks for the help
Create a new Style. Or in a more detailed fashion : create a new Style from default and name it something like euro. Under the numbers tab select currency. The default currency formatting will appear in the box at the bottom of the window. You should get something that looks like
Code: Select all
[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00
Replace the second $ signs with the € sign and you should get something like
Code: Select all
[$€-1009]#,##0.00;[RED]-[$€-1009]#,##0.00
and you're done. Just paste the above code. Otherwise the € can be found in Insert > Special Characters >Currency Symbols.
Re: Currency Convert Entire Calc Document
Posted: Tue Apr 02, 2013 3:19 pm
by Alabandit
Thanks! That's perfect! I never use styles in excel but makes perfect sense!