changing default currency in balance sheet

H

harvestman

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

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
Values in 'Balance sheet' template are in $ I want £ but there is. 2
Insert Rows in Balance Sheet Template 2
balance sheet template in excel adding lines 1
Cell in new sheet should always refer to defined cell in another s 8
Running balance from previous sheet 1

Top