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