Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Values in 'Balance sheet' template are in $ I want £ but there is.
I wanted to use a simple excel balance sheet and instead of creating one I
opened the template in 'new office documents', but all the monetary values I enter come with a $ prefix. I assumed I could change this to £ which is what I wanted but there was no way to do this. I went to 'format' but 'cells' was greyed out. Why is this? |
#2
|
|||
|
|||
The sheet is protected.
ToolsProtectionUnprotect Sheet. No password is required. Gord Dibben Excel MVP On Thu, 2 Dec 2004 11:41:05 -0800, amulcrone wrote: I wanted to use a simple excel balance sheet and instead of creating one I opened the template in 'new office documents', but all the monetary values I enter come with a $ prefix. I assumed I could change this to £ which is what I wanted but there was no way to do this. I went to 'format' but 'cells' was greyed out. Why is this? |
#3
|
|||
|
|||
Toolsprotectionunprotect sheet
if it asks for a password the author obviously wanted it to be non editable, Regards, Peo Sjoblom "amulcrone" wrote: I wanted to use a simple excel balance sheet and instead of creating one I opened the template in 'new office documents', but all the monetary values I enter come with a $ prefix. I assumed I could change this to £ which is what I wanted but there was no way to do this. I went to 'format' but 'cells' was greyed out. Why is this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Linking to an Entire Sheet | Links and Linking in Excel | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
balance sheet template in excel adding lines | Excel Discussion (Misc queries) |