Home |
Search |
Today's Posts |
#1
|
|||
|
|||
custom button to convert into euro on toolbar
does anybody know how to create a custom button on the formatting toolbar
that converts data into euro and without decimals? thanks! |
#2
|
|||
|
|||
Hi Jigio, Have you tried the Euro Currency Tools Add-in? Although this isn't all that good, really! Your best bet is to insert another column with formulas to convert that are driven by a cell containing the exchange rate that can be changed every day, if necessary. You can then format the cells as you please. This also removes the need to run a macro using a toolbar button. Good luck, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401869 |
#3
|
|||
|
|||
hi roly, thanks for the reply. I am using so often spreadsheet with euro data
that one custom button to add the euro sign and remove the decimal would just be perfect. i'll check out the euro currency add-in. thanks "roly" wrote: Hi Jigio, Have you tried the Euro Currency Tools Add-in? Although this isn't all that good, really! Your best bet is to insert another column with formulas to convert that are driven by a cell containing the exchange rate that can be changed every day, if necessary. You can then format the cells as you please. This also removes the need to run a macro using a toolbar button. Good luck, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401869 |
#4
|
|||
|
|||
just installed the add-in...that's great for what i am looking for! thanks
"jigio" wrote: hi roly, thanks for the reply. I am using so often spreadsheet with euro data that one custom button to add the euro sign and remove the decimal would just be perfect. i'll check out the euro currency add-in. thanks "roly" wrote: Hi Jigio, Have you tried the Euro Currency Tools Add-in? Although this isn't all that good, really! Your best bet is to insert another column with formulas to convert that are driven by a cell containing the exchange rate that can be changed every day, if necessary. You can then format the cells as you please. This also removes the need to run a macro using a toolbar button. Good luck, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401869 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom toolbar button icons | Excel Discussion (Misc queries) | |||
How do I save a custom toolbar? | Excel Discussion (Misc queries) | |||
Toolbar button error? | Excel Discussion (Misc queries) | |||
I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |