Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit data entry to 1/4" increments
I have a need to create a input sheet that only lets the user input
numbers in 1/4" increments like 33.00 33.25 33.50 33.75 50.25 22.75 NO 33.125 or 43.375 numbers. Is there some way with data validation or other way? I tried cell formating but it only displays it as a fraction. I want it to reject a entry that does not equal a number on the quarter inch increment. Thanks Scott |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit data entry to 1/4" increments
Use Data ValidationAllowCustomFormula:
=MOD(A1,0.25)=0 -- Biff Microsoft Excel MVP wrote in message ... I have a need to create a input sheet that only lets the user input numbers in 1/4" increments like 33.00 33.25 33.50 33.75 50.25 22.75 NO 33.125 or 43.375 numbers. Is there some way with data validation or other way? I tried cell formating but it only displays it as a fraction. I want it to reject a entry that does not equal a number on the quarter inch increment. Thanks Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
copy data from one sheet to another "entry has to be same shape" | Excel Discussion (Misc queries) | |||
How can you limit the data entry range in Excel? | Excel Worksheet Functions | |||
"Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
Data entry "+" results in "294" in XLS | Excel Discussion (Misc queries) |