£ 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
 
Top