R
Randy
I wonder if anyone knows how to have a column in Excel 2003
automatically formatted to a particular currency when this particular
currency is selected from a drop down list in another cell?
i.e,;
Cell H14 has a drop down list to select USD, CAD, GBP, AUS or IDR.
Cells G20 to G30 contain the Price column that I want to have
automatically formatted to 2 decimal places for all currencies except
the Indonesion Rupiah where I don't want any decimal places.
Should I use a formula to start a macro or something like that.
automatically formatted to a particular currency when this particular
currency is selected from a drop down list in another cell?
i.e,;
Cell H14 has a drop down list to select USD, CAD, GBP, AUS or IDR.
Cells G20 to G30 contain the Price column that I want to have
automatically formatted to 2 decimal places for all currencies except
the Indonesion Rupiah where I don't want any decimal places.
Should I use a formula to start a macro or something like that.