Displaying all numbers as positive

T

TeddyTash

Ok hope you guys can help:

A1= x
A2= y
A3= A1-A2

If the answer is a positive number I want it to remain as a positiv
number
-but-
If the answer is a negative number, I wish for it to be displaye
without the "-" sign before the number so it looks like it's a positiv
number. But I also want it to hold it's negative value so that it can b
used later on.

Example:
A1= 5
A2= 8
A3= A1-A2

A3 Normally displays "-3", I want it to display "3".

But I also need it so that if I make A4=A3, then A4 will display "-3"

Hope this makes sense to someone!


Thanks in advance,
Tedd
 
R

Ron Coderre

Try using a custom number format:

Select the cells to be impacted.
From the Excel main menu:
<format><cells><number tab>
Category: Custom
Type: #,##0;#,##0;#,##0

Note that format contains 3 sections: postive display, negative display,
zero display
Experiment with other options if you need to.

Also, look up "number format" in Excel help for other options.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
T

TeddyTash

Thank you Ron,



Ron said:
Try using a custom number format:

Select the cells to be impacted.
From the Excel main menu:
formatcellsnumber tab
Category: Custom
Type: #,##0;#,##0;#,##0

Note that format contains 3 sections: postive display, negativ
display,
zero display
Experiment with other options if you need to.

Also, look up "number format" in Excel help for other options.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


:
-

Ok hope you guys can help:

A1= x
A2= y
A3= A1-A2

If the answer is a positive number I want it to remain as a positive
number
-but-
If the answer is a negative number, I wish for it to be displayed
without the "-" sign before the number so it looks like it's
positive
number. But I also want it to hold it's negative value so that it ca
be
used later on.

Example:
A1= 5
A2= 8
A3= A1-A2

A3 Normally displays "-3", I want it to display "3".

But I also need it so that if I make A4=A3, then A4 will display "-3"

Hope this makes sense to someone!


Thanks in advance,
Teddy
Click to expand...
 
Top