Data Validation issue

Hello,

See Attached File: Original Sheet form HSV from this forum.

The drop down menu shows all names in range and when you start typing it filters and shows you only the results you are looking for.

It works great with string, but not with numbers. See attached sheet and try enter first "m" and it shows the choices for "m" and then enter "3" it shows none.

Please help. thanks

Originally Posted by davesexcel

When i formatted you data validation cells as text and entered 3 then used the dropdown, 350 showed up

You are a GENIOUS! Thanks so much.