View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brijay Brijay is offline
external usenet poster
 
Posts: 1
Default How can I always display numbers produced from subtractionas posit

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.