Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation of cells containing percent
How do I make a validation rule for a cell containing percent? I would like
to insert the validation rule, that the cell-value should be between 0 and 100. -- Jane |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation of cells containing percent
With the cell formatted as Percent, the values in it will actually be decimal
values. Set your data validation to type Decimal and then select value Between and use 0 as the lower limit and 1 as the upper limit. "Jane" wrote: How do I make a validation rule for a cell containing percent? I would like to insert the validation rule, that the cell-value should be between 0 and 100. -- Jane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation of cells who is dependent on each other | Excel Discussion (Misc queries) | |||
remove percent symbol on percentage formatted cells in excel | Excel Discussion (Misc queries) | |||
Linked cells with validation | Excel Discussion (Misc queries) | |||
Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
Format Validation Cells | Excel Discussion (Misc queries) |