custom button to convert into euro on toolbar

J

jigio

does anybody know how to create a custom button on the formatting toolbar
that converts data into euro and without decimals? thanks!
 
R

roly

Hi Jigio,

Have you tried the Euro Currency Tools Add-in? Although this isn't al
that good, really!

Your best bet is to insert another column with formulas to convert tha
are driven by a cell containing the exchange rate that can be change
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,


Rol
 
J

jigio

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
 
Top