make cell entries a negative number

[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 McRitchie]

if you use the negative of the absolute value
=-ABS(B32)

 

[gls858]

if you use the negative of the absolute value
=-ABS(B32)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

Ahhh that would work wouldn't it! That thought obviously never
occurred to me

Thanks David,

gls858

 

[CLR]

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]

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

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

gls858