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