changing default currency in balance sheet

G

Guest

I cannot change the default currency in the balance sheet template from
dollars to GB Pounds.

My Windows regional settings are set to GBP and the advice given elsewhere
about selecting the cells and changing from the Format menu does not work -
the required function is greyed out whatever way I try selecting the cells.
 
G

Gord Dibben

Assuming you're talking about the balance sheet template that is found under
Spreadsheet Solutions, the sheet is protected.

Go to Tools>Protection and Unprotect Sheet.

Make your formatting changes to GBP.

Note: after doing this, you must save the workbook as a Template.

File>Save As>File Type>MS Excel Template(*.xlt)

You can overwrite the original if you're feeling confident or give your new
template a unique name.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change of currency in excel 1
how to change from dollars to pounds in a balance sheet 5
Changing language of an existing sheet 4
Changing Dollar sign to another currency not listed in Excel 1
Incorrect Currency Displayed 4
Change currency format in table. 3
Insert Rows in Balance Sheet Template 2
export to XL - problem with currency format from cells 1

Top