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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Language of the templates 0
Sorting personal templates alphabetically in Office 365 for mac OS? 3
creating new template - change default heading style 7
Global Template Network and saving auto texts & macros 2
Text in note pane of "normal" display suddenly much larger 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Modern equivalent of Autotext in Word? 0
Old question regarding Access Templates. Any up to date answers, please 2

Top