ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I assign a symbol to a button (like the $ button) (https://www.excelbanter.com/excel-discussion-misc-queries/41562-how-can-i-assign-symbol-button-like-%24-button.html)

NickW

How can I assign a symbol to a button (like the $ button)
 
I'm trying to get a button with the UK pound sign on it (lira). But all I can
get is the US dollar or the Euro.
Using excel 2003

Thanks
N

Ian

If you're referring to a keyboard button, then you need a UK keyboard with
Windows configured to expect it, then Shift 3 will produce the symbol..

If you don't have a UK keyboard, you can get the pound sign by holding down
Alt and pressing 1 5 6 on the numeric keypad.

--
Ian
--
"NickW" wrote in message
...
I'm trying to get a button with the UK pound sign on it (lira). But all I
can
get is the US dollar or the Euro.
Using excel 2003

Thanks
N




NickW

I've found another (easier) way.
Go to insert symbol and find the Lira sign (or any symbol you want).
Select the symbol and at the bottom of the screen there's a button to allow
you to assign a key stroke to that symbol. I assinged CTRL-4 (4 is the $
button). Now whenever I need it all I hahve to do is a CTRL-4!!

Thanks for the feedback though!

Nick

"Ian" wrote:

If you're referring to a keyboard button, then you need a UK keyboard with
Windows configured to expect it, then Shift 3 will produce the symbol..

If you don't have a UK keyboard, you can get the pound sign by holding down
Alt and pressing 1 5 6 on the numeric keypad.

--
Ian
--
"NickW" wrote in message
...
I'm trying to get a button with the UK pound sign on it (lira). But all I
can
get is the US dollar or the Euro.
Using excel 2003

Thanks
N






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

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