| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Link a button to a specific format
On my Excel 2003 I can use the Euro (?) button to format the current
selection in Euro format. I now wish to replace the Euro currency symbol with my own symbol, i.e. "Fr.* ". How can I link the Euro button to this format? There is no need to change the face of the button itself - I'm happy to leave it as the ? button. |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Link a button to a specific format
By "button" do you refer to a key on the keyboard or the menu icon?
best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Pegasus [MVP]" wrote in message ... On my Excel 2003 I can use the Euro (?) button to format the current selection in Euro format. I now wish to replace the Euro currency symbol with my own symbol, i.e. "Fr.* ". How can I link the Euro button to this format? There is no need to change the face of the button itself - I'm happy to leave it as the ? button. |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Link a button to a specific format
Opps! you talk about 'face' so is the icon. The machine I am using has only
XL2007 but I believe in XL2003 you can open the Font menu item, go the Styles and change the Accounting and/or Currency style best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Pegasus [MVP]" wrote in message ... On my Excel 2003 I can use the Euro (?) button to format the current selection in Euro format. I now wish to replace the Euro currency symbol with my own symbol, i.e. "Fr.* ". How can I link the Euro button to this format? There is no need to change the face of the button itself - I'm happy to leave it as the ? button. |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Link a button to a specific format
Bingo - you were spot on! Thanks for the prompt response.
"Bernard Liengme" wrote in message ... Opps! you talk about 'face' so is the icon. The machine I am using has only XL2007 but I believe in XL2003 you can open the Font menu item, go the Styles and change the Accounting and/or Currency style best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Pegasus [MVP]" wrote in message ... On my Excel 2003 I can use the Euro (?) button to format the current selection in Euro format. I now wish to replace the Euro currency symbol with my own symbol, i.e. "Fr.* ". How can I link the Euro button to this format? There is no need to change the face of the button itself - I'm happy to leave it as the ? button. |
|
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
Link a button to a specific format
Glad it is now sorted out
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Pegasus [MVP]" wrote in message ... Bingo - you were spot on! Thanks for the prompt response. "Bernard Liengme" wrote in message ... Opps! you talk about 'face' so is the icon. The machine I am using has only XL2007 but I believe in XL2003 you can open the Font menu item, go the Styles and change the Accounting and/or Currency style best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Pegasus [MVP]" wrote in message ... On my Excel 2003 I can use the Euro (?) button to format the current selection in Euro format. I now wish to replace the Euro currency symbol with my own symbol, i.e. "Fr.* ". How can I link the Euro button to this format? There is no need to change the face of the button itself - I'm happy to leave it as the ? button. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| button to go to specific tab | Excel Discussion (Misc queries) | |||
| How do you save demos (that don't have specific button for this)? | Excel Discussion (Misc queries) | |||
| Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| button link | Excel Discussion (Misc queries) | |||
![Pegasus [MVP] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
