Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I format a cell so that only specific numbers can be enter.
I want to format a cell so that only specific numbers can be entered. For
instance only numbers between 1 and 5 can be entered. All other numbers will either force an error message or simply cannot be entered. |
#2
|
|||
|
|||
Hi Jim
check out data / validation (choose whole number - between 1 & 5 ... you can also write your own error messages on the error alter tab) check out www.contextures.com/tiptech.html for additional details on using Data Validation Cheers JulieD "Jim" wrote in message ... I want to format a cell so that only specific numbers can be entered. For instance only numbers between 1 and 5 can be entered. All other numbers will either force an error message or simply cannot be entered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you enter numbers in a fraction format ? (78/27) | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Format Cell Colour | Excel Worksheet Functions |