software

How do I format a number so that it display a minus sign before the number. I
have a spreadsheet that was created by someone else, and it does this, but I
cannot figure out how to do it!

Is it all or part of the numbers in a column? Either way, enter the
number in the cell with a - sign. Then click on the column, select
FORMATgt;CELLSgt;NUMBER, select the type of number you are using (currency,
general, number, etc.) and you'll see a box for negative numbers. Pick
your pleasure and voila--it will show that way on your spreadsheet.If you'[ll right-click a cell, a window pops up and allows you to
choose the visual display of a number.I should have mentioned the cell format is Accounting and the number is not a
negative, it is however used in a formula. For example =A3-A2

quot;SharonJoquot; wrote:

gt; How do I format a number so that it display a minus sign before the number. I
gt; have a spreadsheet that was created by someone else, and it does this, but I
gt; cannot figure out how to do it!

I should have mentioned the cell format is Accounting and the number is not a
negative, it is however used in a formula. For example =A3-A2

quot;Not Excellingquot; wrote:

gt; Is it all or part of the numbers in a column? Either way, enter the
gt; number in the cell with a - sign. Then click on the column, select
gt; FORMATgt;CELLSgt;NUMBER, select the type of number you are using (currency,
gt; general, number, etc.) and you'll see a box for negative numbers. Pick
gt; your pleasure and voila--it will show that way on your spreadsheet.
gt;
gt;

I should have mentioned the cell format is Accounting and the number is not a
negative, it is however used in a formula. For example =A3-A2

quot;Dave Oquot; wrote:

gt; If you'[ll right-click a cell, a window pops up and allows you to
gt; choose the visual display of a number.
gt;
gt;

Right Click the Cell and select format cells. Click on the Number Tab the
select custom. Enter this as your custom number format.

-#

now all number will have an extra - in front. (ie 12 will show as -12, and
-12 will show as --12). if you want only one - for negative numbers use this
format

-#;-#

if you want 0 to show as -0, use this format

-0;-#

quot;SharonJoquot; wrote:

gt; I should have mentioned the cell format is Accounting and the number is not a
gt; negative, it is however used in a formula. For example =A3-A2
gt;
gt; quot;SharonJoquot; wrote:
gt;
gt; gt; How do I format a number so that it display a minus sign before the number. I
gt; gt; have a spreadsheet that was created by someone else, and it does this, but I
gt; gt; cannot figure out how to do it!


(formula)*-1--
mcr1
------------------------------------------------------------------------
mcr1's Profile: www.excelforum.com/member.php...oamp;userid=15496
View this thread: www.excelforum.com/showthread...hreadid=498875
I'm not an expert but should it not be:

=A2-A3

or

=MIN(A2:A3)-MAX(A2:A3)

just a thought!

JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498875