make cell entries a negative number

  • Thread starter Thread starter gls858
  • Start date Start date
G

gls858

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
 
David said:
if you use the negative of the absolute value
=-ABS(B32)
Click to expand...
Ahhh that would work wouldn't it! That thought obviously never
occurred to me :-)

Thanks David,

gls858
 
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
 
CLR said:
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
Click to expand...
Thanks Chuck. I'll give your solution a try also.

gls858
 
Back
Top