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? |
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? |
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? |
All times are GMT +1. The time now is 11:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com