View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default =D6-E6 there are brackets?

On Fri, 21 Jul 2006, in microsoft.public.excel.charting,
JillM said:

After gaining a balance from the equation =D6-E6 there are brackets
surrounding the answer. Instead of brackets, when the value has saved money
is it possible for there to be a "+" sign, and when the value has lost money
is it possible to have a "-" sign? How is this possible?


Create a custom number format like so:

+General;-General

This isn't really an appropriate forum to be asking about Excel formulas
and number formatting; it's for questions about Excel charts. Depending
on how you're reading this, there several nearby groups than can help
you more fully.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.