| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula connected to a dropdown list
I am setting up a expense report using drop down lists for TYPE;ie airfare,
taxi, mileage. I also have a column AMOUNT that I have designated to be in currency form. When mileage is selected how do I have the AMOUNT cell convert to number as opposed to currency. Ex: When mileage is selected and I put in the AMOUNT column the number 78 it comes up as $78 and I want it to come up as just 78. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-Down List Connected to a Value | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| How do I reference a formula to a dropdown list | Excel Discussion (Misc queries) | |||
| Dropdown list connected to another workbook | Excel Worksheet Functions | |||
Threaded Mode
