Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, Canadian or Indonesian Rupiah. Cells G20 to G30 contain the Price column that I want to have automatically formatted to either 2 decimal places for USD currency or zero decimal places for the Indonesion Rupiah depending on what is selected in H14. Should I use a formula to start a macro or something like that. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto number formatting | Excel Worksheet Functions | |||
How do I change auto formatting to allow a 0 as the first number | Excel Discussion (Misc queries) | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
how to stop excel from auto formatting whole number to decimal % | New Users to Excel | |||
Auto Formatting Custom Number | Excel Discussion (Misc queries) |