ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   =D6-E6 there are brackets? (https://www.excelbanter.com/charts-charting-excel/100664-%3Dd6-e6-there-brackets.html)

JillM

=D6-E6 there are brackets?
 
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?

Del Cotter

=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.


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com