Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
NickW
 
Posts: n/a
Default 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   Report Post  
Ian
 
Posts: n/a
Default

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   Report Post  
NickW
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign a macro to Command Button Object dallin Excel Discussion (Misc queries) 2 July 13th 05 03:50 AM
How to assign a marco to a command button Eric Excel Worksheet Functions 1 May 30th 05 12:44 AM
How do I Assign Macro to a button? BellExcel Charts and Charting in Excel 4 May 20th 05 07:21 PM
How to assign a macro to a commnd button Mickey Blue Eyes Excel Discussion (Misc queries) 2 January 4th 05 02:15 PM
assign a macro to a control button ewan72 Excel Discussion (Misc queries) 1 December 3rd 04 02:04 PM


All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"