Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
assign auto number and auto date | Excel Discussion (Misc queries) |