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!

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

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

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