Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation, alpha or numeric characters
I need to enter either the letters "nd" in a cell, or a numeric range of less that 5.0. Can this be done with validation? If not "nd" or <5, then I would like spreadsheet to pop up the "stop" box. Please help!!! Thanks!!! -- tsammons ------------------------------------------------------------------------ tsammons's Profile: http://www.excelforum.com/member.php...o&userid=30335 View this thread: http://www.excelforum.com/showthread...hreadid=499996 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation, alpha or numeric characters
If you only want "nd" or the integers between 1 and 4, inclusive: DataValidation Allow: List Source: nd,1,2,3,4 Alternatively, If you only want "nd" or any numeric value less that 5, try this: DataValidation Allow: Custom Formula: =or(A1="nd",A1<5) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499996 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation, alpha or numeric characters
One way ..
Assume inputs would be made in col A, A1 down Select col A Click Data Validation Select Custom under "Allow" Put as the "Formula:" =OR(A1<5,A1="nd") Click OK Test it out .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "tsammons" wrote in message ... I need to enter either the letters "nd" in a cell, or a numeric range of less that 5.0. Can this be done with validation? If not "nd" or <5, then I would like spreadsheet to pop up the "stop" box. Please help!!! Thanks!!! -- tsammons ------------------------------------------------------------------------ tsammons's Profile: http://www.excelforum.com/member.php...o&userid=30335 View this thread: http://www.excelforum.com/showthread...hreadid=499996 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation, alpha or numeric characters
Thank you soooo much . . . this worked. -- tsammons ------------------------------------------------------------------------ tsammons's Profile: http://www.excelforum.com/member.php...o&userid=30335 View this thread: http://www.excelforum.com/showthread...hreadid=499996 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation, alpha or numeric characters
You're welcome (from us) !
Believe Ron arrived fractionally ahead (1 min? <g), and provided a more comprehensive response with 2 options -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "tsammons" wrote in message ... Thank you soooo much . . . this worked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alpha numeric data validation for excel | Excel Worksheet Functions | |||
A validation rule on Alpha and Numeric characters | Excel Worksheet Functions | |||
Formulas that include alpha and numeric characters | Excel Worksheet Functions | |||
Can you ID a cell that has both Alpha AND Numeric characters? | Excel Worksheet Functions | |||
code that can distinguish between alpha and numeric characters | Excel Programming |