Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
Jason Maskell
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending from excel to word template pizdus Excel Discussion (Misc queries) 0 January 17th 06 05:57 PM
Excel 2000 Invoice Template Macro Password? Bill Excel Discussion (Misc queries) 1 December 16th 05 10:29 PM
Need One Excel Template to copy to TWO Databases gildo4realdo Excel Discussion (Misc queries) 0 July 29th 05 03:57 PM
how do I change an excel template into a "workbook" joyce Excel Discussion (Misc queries) 5 April 14th 05 04:38 PM
Excel 98 Invoice Template Guntherg Excel Worksheet Functions 1 December 13th 04 12:05 PM


All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"