Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have few fields in excel where I should input numeric data (i.e.
days of the week - from 1 to 7) Anybody know how can I limit cell to allowing input on juts one number to prevent wrong input? Limiting decimal places is easy but limiting main numeric field...? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Highlight the cell and click on Data-Validation. Select "whole number" in
the first box. Select "Between" in the second. And input 1 and 7 as the minimun and maximum. " wrote: I have few fields in excel where I should input numeric data (i.e. days of the week - from 1 to 7) Anybody know how can I limit cell to allowing input on juts one number to prevent wrong input? Limiting decimal places is easy but limiting main numeric field...? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |