Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
How to assign a marco to a command button | Excel Worksheet Functions | |||
How do I Assign Macro to a button? | Charts and Charting in Excel | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
assign a macro to a control button | Excel Discussion (Misc queries) |