But I only want that text to appear when the results are a negative.

So, I want to format or put a formula on a column of cells that have
calculations in them (subtractions, mainly)... but in the rare case that the
calc comes out with a negative, I want the number (without a minus sign) and
the text "over est." to appear in that cell.

I don't think just formatting the cell will actually do it. I'm thinking
it's got to be a formula but I'm just so new to formulas. I've searched thru
all postings having anything to do with Negatives to Positives to inserting
text, etc... but nothing was even close.

You guys have gotten the closest but it's still not doing what I know it can
do and what I need it to do.

Any more ideas? pointers?

Maybe I'll have to skip the whole idea of the text and maybe just add some
formatting if it's negative -- like a flashy color or something... I dunno.
I just figured there's GOT to be a way!

"Peo Sjoblom" wrote:

Just the minus?

#,##0;#,##0" overage";0;@

--

Regards,

Peo Sjoblom

"Nicole L." wrote in message
...
How do I get rid of the "-" in this case?

"Harlan Grove" wrote:

Nicole L. wrote...
I have a cell (G1) that is the sum or some other calculation of other
cells
(SUM(C1:F1))...
What formula do I use to say that IF that calculation turns out to be
a
negative, I'd like a word added, such as "overage" or something?

If you just want negative numbers to display differently, use a custom
number format. Format Cells, Number tab, select Custom from the
Category list, then in the type field enter

#,##0;-#,##0" overage";0;@