View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 14
Default negative numbers

Raysa

If you mean that you formatted the cell so that it does not show the "-"
sign then yes it is still a negative number. You can prove this by setting
another cell equal to the first cell (ie. if the number is in A1 set B1 to
=A1) and format the new cell to general or number and it should show the "-"
sign.

If you mean that you muliplied the number by -1 to remove the "-" sign or id
a ABS() of the cell then no it is no longer negative.

Dave

"raysa" wrote in message
...
when you format negative numbers into positive numbers is it still a
negative
number?