I want to change an online template to read in £'s not $

R

Rummy

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
 
G

Gord Dibben

I would say that 99% of the templates from the template gallery that have sheet
protection enabled have no password so just go to Tools>Protection>Unprotect
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
 
Top