View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How can I always display numbers produced from subtractionas posit

Hi,

=ABS(b1-a1)

Mike

"Brijay" wrote:

How do I display, say "1000 minus 2000" as "1000" Instead of "-1000". However
if the two numbers entered were then changed to say, "2000 minus 1000" it
would STILL produce the answer "1000" - again, a positive number.