worked like a treat - thanks

"bigwheel" wrote:

> Try data validation and set the validation criteria to numbers less than zero
>
> "George" wrote:
>
> > I would like to protect a cell so that the number that is entered must be a
> > negative number. Is this possible?
> > e.g if 654 is entered - the cell rejects this positive number.
> > George