General discussion

Locked

UK Pound Symbol & Excel

By hlittkb ·
Would appreciate guidance on how to add the UK Pound symbol in an Excel spreadsheet cell? i'm using a US keyboard.
Thank you n Happy New Year.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Joseph Moore In reply to UK Pound Symbol & Excel

On your keyboard, hold the ALT key down, then on the 10-key pad, type in 0163, then let go of the ALT key.
Voila!
?

hope this helps

Collapse -

by hlittkb In reply to

Poster rated this answer.

Collapse -

by DKlippert In reply to UK Pound Symbol & Excel

To just format your numbers as currency with a ? symbol, select the range, go to Format>Cells.
On the Number tab select the Currency Category.
Scroll down the Symbol: list.
? is the first symbol after all of the $ signs.

Collapse -

by hlittkb In reply to

Poster rated this answer.

Collapse -

by hlittkb In reply to UK Pound Symbol & Excel

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums