cell data validation

  • Thread starter Thread starter eggpap
  • Start date Start date
E

eggpap

Hello,

in one Excel2003 task I have some cells linked to a code list to get the
data validation.
The codes in the list are numbers or mixed numbers and letters.

The mixed codes can be indifferenctly selected from the dropdown list in the
cell
or directly typed in it, the code numbers, instead, can be only selected
from the
dropdown list. I get error if I type it in the cell directly (item not
present in the list).

When the user knows the code would be easier to type it directly in the
cell.


Emiliano
 
the code numbers, instead, can be only selected from the dropdown list.

The problem is likely that the "numbers" in the list and the data entry cell
itself have different number formats. If one is number formatted or General
and the other is Text formatted they will not match.

That is because, for example, the number 234 does not match the text "234".

--
Jim
| Hello,
|
| in one Excel2003 task I have some cells linked to a code list to get the
| data validation.
| The codes in the list are numbers or mixed numbers and letters.
|
| The mixed codes can be indifferenctly selected from the dropdown list in
the
| cell
| or directly typed in it, the code numbers, instead, can be only selected
| from the
| dropdown list. I get error if I type it in the cell directly (item not
| present in the list).
|
| When the user knows the code would be easier to type it directly in the
| cell.
|
|
| Emiliano
|
|
|
|
 
You are right,
many thanks

Emiliano

Jim Rech said:
The problem is likely that the "numbers" in the list and the data entry
cell
itself have different number formats. If one is number formatted or
General
and the other is Text formatted they will not match.

That is because, for example, the number 234 does not match the text
"234".

--
Jim
| Hello,
|
| in one Excel2003 task I have some cells linked to a code list to get the
| data validation.
| The codes in the list are numbers or mixed numbers and letters.
|
| The mixed codes can be indifferenctly selected from the dropdown list in
the
| cell
| or directly typed in it, the code numbers, instead, can be only selected
| from the
| dropdown list. I get error if I type it in the cell directly (item not
| present in the list).
|
| When the user knows the code would be easier to type it directly in the
| cell.
|
|
| Emiliano
|
|
|
|
Click to expand...
 
Back
Top