| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative percentage in data verification dropdown list?
Is it possible to have a negative percentage a in data verification list as
one of the choices in the dropdown list ? Negative percentages display incorrectly in a percentage-formatted cell, and don't calculate correctly in formulas. Positive .01 displays as 1% and correctly calculates, but negative -.01 dislpays as -.01 and creates an entirely incorrect value when run through my formulas. I've also tried .-01. Any secrets out there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown list for entering data | Excel Discussion (Misc queries) | |||
| Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
| Dropdown list and filtered data | Excel Discussion (Misc queries) | |||
| Data validation with dropdown list | Excel Discussion (Misc queries) | |||
| Entering data from dropdown list | Excel Discussion (Misc queries) | |||
Threaded Mode
