£ sign

G

Gord Dibben

Alex

Format>Cells>Currency>Symbol. Scroll down and select the English(United
Kingdom).

Alternative.......

Format>Style>Currency>Modify. Set to your liking and OK.

When you click on the Currency Button on the Formatting Toolbar, that Style
will be your format.

Gord Dibben Excel MVP
 
C

Chris R. Lee

Don't think many people are interested any more in these piddling local
currencies ;-)

European regards
 

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

Microsoft 365 Activations, Users or Devices? 0
Office365 Outlook for work email change signature how ? 0
Dropdown with signatures 1
Save mulit-page two-sided document as a PDF 1
Replace 9
Disable auto-input of cell when typing a minus 0
Px using Word 2016 on iPad & iPhone 0
Cannot open embedded file in digitally signed document 0

Top