Validation - List value or any number

[grey]

Is there any way to add data validation that will accept either:
- string values from a drop down list
or
- any number

so for example, the user can either enter:
S
M
L
XL
or any numerical measurement

So I need them to be able to select the strings from a drop down list, or they can free type a number

[sweep]

Hi,

I don't think that you can have a list or optional free-entry. However,

using the custom option in data validation, use the following formula

=OR($A1="S",$A1="M",$A1="L",$A1="XL",ISNUMBER($A1))

Note that A1 must reside at the top of the validated list.