ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   I want to change an online template to read in £'s not $ (https://www.excelbanter.com/new-users-excel/142546-i-want-change-online-template-read-%C2%A3s-not-%24.html)

Rummy

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

Gord Dibben

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




All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com