[Solved] Currency Convert Entire Calc Document

[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!

[jrkrideau]

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.

[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

[jrkrideau]

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.

[Alabandit]

Thanks! That's perfect! I never use styles in excel but makes perfect sense!