Quote Originally Posted by mikerickson
It looks like the problem isn't in data Validation, but that when you type "3/2" into a cell, Excel "sees" March 2 rather than 1.5 or when you type "100/2" into a cell, it sees a string rather than 50.
Not if the cell is formatted as text, as I had assumed.