=D6-E6 there are brackets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JillM - 21 Jul 2006 13:53 GMT

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?

Reply to this Message

Del Cotter - 21 Jul 2006 20:03 GMT

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

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message