CLR wrote:
If you are depending on others to enter only negative numbers, you can set
up Data Validation to accept only negative numbers in that cell, and
provide an error message to remind users as well.

Vaya con Dios,
Chuck, CABGx3


"gls858" wrote in message
...

I have a situation where I would like the number entered into
a cell to always be a negative number. Seems like it should
be easy but I can't seem to get it. Any suggestions?

gls858



Thanks Chuck. I'll give your solution a try also.

gls858