auto number formatting
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. |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com