make cell entries a negative number
 

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

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

"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

David McRitchie wrote:
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

"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



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


"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

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