Currency Covert Entire Calc Document

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!

It’s about the formatting of the cells so that they reflect the € not the € icon in the cell. I have a working formula.

I have uploaded a simple example to dropbox, as I don’t have any Karma yet, Dropbox - File Deleted, 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 automatical

I think it should be possible with find and replace Ctrl+H using regular expressions, replacing values with =values/change.

But is needed more information on how the data are in the spreadsheet:
Are they the only numbers values in the range where they are?

Or with paste special Shit+Ctrl+V.
Insert the change value in a non used cell.
Copy from this cell.
Select the range to change.
Paste special - Operations - divide

I am not sure if this fits to the $-spreadsheet as it is built right now.

Assumption: your $ spreadsheet is on sheet$ and covers A1:D100 with cells containing $-values to be converted into EUR, and cells with other information which should not be changed

on sheet$=EUR place the conversion rate you want to you use in cell A1

on sheetEUR create links to sheet$ and wherever you need to recalculate the figures multiply with the exchange rate of A1 on sheet$-EUR but use absolute reference to A1, thus $A$1

Once this is done you might want to break the link

got the answer from jrkrideau at http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=60754&p=269285#p269285

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

[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00

Replace the second $ signs with the € sign and you should get something like

[$€-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.

The same thing would be changing number format for the necassary cells to currency and choosing a format with euro. I tried it on your sheet, at first nothing happened, but I tried deleting cell value that is used in calculations (F19 in your sheet) and wrote it again and after automatically re-calculating values, the currency changed too.