most time the input for the cell will be 2.42,but i want to
have,2.72,3.02,3.32,3.62 as options,PLUS the ability to type an
alternative,So a data validation list doent work,drop down arent editable,and
i cant figure out how to get(or use) an output from a data list.So am i
forced to use a drop down or data validation list with an optional input
cell???
--
paul
remove nospam for email addy!

Go to Debra Dalgleish's web site:

http://www.contextures.com/tiptech.html

Scroll down to the D's, and read all about Data Validation and how to
accomplish exactly what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"paul" wrote in message
...
most time the input for the cell will be 2.42,but i want to
have,2.72,3.02,3.32,3.62 as options,PLUS the ability to type an
alternative,So a data validation list doent work,drop down arent
editable,and
i cant figure out how to get(or use) an output from a data list.So am i
forced to use a drop down or data validation list with an optional input
cell???
--
paul
remove nospam for email addy!

Hi!

You can use a data validation drop down and disable the error alert. The
cell will accept anything you type in (the "alternative") or a pick from the
list.

Biff

"paul" wrote in message
...
most time the input for the cell will be 2.42,but i want to
have,2.72,3.02,3.32,3.62 as options,PLUS the ability to type an
alternative,So a data validation list doent work,drop down arent
editable,and
i cant figure out how to get(or use) an output from a data list.So am i
forced to use a drop down or data validation list with an optional input
cell???
--
paul
remove nospam for email addy!

thanks Guys,great help,and Biff sometimes its the easiest thing hey!
--
paul
remove nospam for email addy!



"Biff" wrote:

Hi!

You can use a data validation drop down and disable the error alert. The
cell will accept anything you type in (the "alternative") or a pick from the
list.

Biff

"paul" wrote in message
...
most time the input for the cell will be 2.42,but i want to
have,2.72,3.02,3.32,3.62 as options,PLUS the ability to type an
alternative,So a data validation list doent work,drop down arent
editable,and
i cant figure out how to get(or use) an output from a data list.So am i
forced to use a drop down or data validation list with an optional input
cell???
--
paul
remove nospam for email addy!