If you use the metric sheet on the Base Price Spreadsheet, you might prefer to see the prices in your own currency. Since that might mean EUROs, AUD, or some other currency, this is a change you will need to make on your own. But no worries--it is very easy!
This spreadsheet has the potential to be modified to better suit your particular needs, so I'll provide tips as I think of them.
Before you start modifying your spreadsheet, you might save a copy as the original, and then save it again under a different name. Then you'll have one to play with and make changes, and also an original as a back-up.
How to Change the Currency
1. Highlight the column F by clicking the letter "F". The column will turn blue showing it is selected.
2. Then go to:
> Format
> Cells
> Select the "Numbers" tab
> Set the "Category" to "Currency"
> Using the "Format" drop down box, select your currency
> Click "ok"
3. Repeat steps 1 & 2 for column G & then column H. You can do all three columns at once, but notice how column G has 4 decimal places? That is because the amount is so small that showing only 2 decimal places displays amounts of $0.00. That seems confusing to me and looks like an error, even though the underlying amounts are there and calculating.
So if you change all three columns at once, what will happen is the G column will now only have 2 decimal places. Maybe it won't bother you to see the $0.00 amount, but I wanted to point that out.
4. Repeat step #2 to change the currency displayed in cells A14 and C11. You can do both of these at the same time by clicking one and then holding down CTRL and clicking the other.
One More Change You Might Want to Make
Besides the currency change, one other thing you might do is to either move Metric to be the first sheet, so the spreadsheet automatically opens to Metric. Or you can hide the Standard sheet if you won't be needing it and want it to go away.
To move the Metric sheet:
> Click the sheet name and hold the mouse down
> Drag it in front of Standard
To hide the Standard sheet go to:
> Format
> Sheet
> Hide
Look for more OpenOffice tips soon! I love OO and have another VERY special document coming out next week that uses OpenOffice. Stay tuned!
