ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   using excel invoice template need to change $ to £ (https://www.excelbanter.com/setting-up-configuration-excel/96682-using-excel-invoice-template-need-change-%24-%C2%A3.html)

Jason Maskell

using excel invoice template need to change $ to £
 
Based in UK

Using excel invoice template, when I add my figures and tab across a $ sign
comes up. I need to change this to a £ sign, but how.

Any help welcome.

Thanks Jason

Gord Dibben

using excel invoice template need to change $ to £
 
Jason

The Invoice sheet is protected.

ToolsProtectionUnprotect sheet...no password required.

Select L19:M40 and FormatCellsNumberCurrencySymbol.

Scroll down until you find the English Pound sign.


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 12:07:02 -0700, Jason Maskell <Jason
wrote:

Based in UK

Using excel invoice template, when I add my figures and tab across a $ sign
comes up. I need to change this to a £ sign, but how.

Any help welcome.

Thanks Jason




All times are GMT +1. The time now is 07:20 PM.

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