Is it possible to set a cells data validation to accept inputs of anything except a certain value? i.e. I want to set a number of cells on a worksheet to accept the input of any value (Figures or numbers) except 0 (zero).
The data validation menu appears to only let me set what to allow rather than what NOT to allow.
Any help will be appreciated
Thanks
Bookmarks