| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I want to change an online template to read in £'s not $
I have downloaded a couple of accounting templates, but they read in $, i
would like to read them in £'s - any suggestions. I have tried but the cells are locked and i'm no expert - pls advice |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
I want to change an online template to read in £'s not $
I would say that 99% of the templates from the template gallery that have sheet
protection enabled have no password so just go to ToolsProtectionUnprotect Sheet. The re-format as you wish. Some cells may have data validation rules so you have to alter those if need be. Gord Dibben MS Excel MVP On Sat, 12 May 2007 17:21:00 -0700, Rummy wrote: I have downloaded a couple of accounting templates, but they read in $, i would like to read them in £'s - any suggestions. I have tried but the cells are locked and i'm no expert - pls advice |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't open online Help - get "Register for My Office Online" | Excel Discussion (Misc queries) | |||
| Online Shopping template or formulas | Excel Discussion (Misc queries) | |||
| Please put a remittance advice template online | Excel Worksheet Functions | |||
| how can i change column to read a.b.c.etc and not 1.2.3. | Excel Discussion (Misc queries) | |||
| create read only template that links to databa... | New Users to Excel | |||
Linear Mode
