How to make negative numbers look like 0

  • Thread starter Trisha V via OfficeKB.com
  • Start date
T

Trisha V via OfficeKB.com

I need to find out how you make negative numbers look like 0's instead of
making them negative

for example....

I have a -25 and I need it to look like this "0". This way positive numbers
are the only things I have listed on my column.

Is this posibble?
 
T

Trisha V via OfficeKB.com

how do you this with %'s ?...I need them to become zeros as well...
 
T

Trisha V via OfficeKB.com

ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A
FORMULA.
 
G

Gordon

Trisha V via OfficeKB.com said:
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN
WITH A FORMULA.
Click to expand...

No. There isn't. You can't "format" a cell to show a non-negative number.
What's the problem with putting the formula in a column next to the
original, and then hiding the original column?
 
T

Trisha V via OfficeKB.com

I GUESS YOU'RE RIGHT..THANKS
No. There isn't. You can't "format" a cell to show a non-negative number.
What's the problem with putting the formula in a column next to the
original, and then hiding the original column?
Click to expand...
 
T

Trisha V via OfficeKB.com

ACTUALLY THIS IS NOT THAT EASY TO DO WHEN YOU'RE WORKING WITH A PIVOT TABLE
 
T

Trisha V via OfficeKB.com

IM ACTUALLY STILL HAVING A PROBLEM WITH IT...IM GETTING AN ERROR MESSAGE
#DIV/0!

THIS I DONT KNOW HOW TO FIX...MAYBE IF I CAND SEND WHAT IM WORKING ON TO
SOMEONE BECAUSE I CANT EVEN EXPLAIN WHATS WRONG....ITS A BIGGGGG FILE.
 
B

Bernie Deitrick

Trisha,

A custom format of

0;"0";0

will display negative numbers as zero, though it won't change the underlying value.

HTH,
Bernie
MS Excel MVP
 
T

Trisha V via OfficeKB.com

thanks

Bernie said:
Trisha,

A custom format of

0;"0";0

will display negative numbers as zero, though it won't change the underlying value.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
U

ufo_pilot

Trisha said:
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WIT
A
FORMULA.
Click to expand...


use conditional format if cell value < than 0 then format the tex
same color as background - so it seems to dissappea
 
Top