Can data validation be set up to accept a 0( (zero) or any whole number
between 25,000 and 10,000,000? Or does this have to be controlled with VBA?

This needs to work with xll03 and later versions