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
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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
>
>>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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks