| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set a column to accept only a specified number of digits
Hi, Can u tell me how to set a column in excel to accept only a specif number of digits? for example ... i want column A to accept onl numbers in the range 1-100. If 101 is type an error must be displayed Thank -- ashvi ----------------------------------------------------------------------- ashvik's Profile: http://www.excelforum.com/member.php...fo&userid=2754 View this thread: http://www.excelforum.com/showthread.php?threadid=47070 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| number 12 digits to 15 digits | Excel Discussion (Misc queries) | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| format a cell to accept a date or a whole number | Excel Discussion (Misc queries) | |||
| How to set a column to accept only a specified number of digits | Excel Worksheet Functions | |||
Threaded Mode
