I'm using the custom format: #,##0;-#,##0" over est.";0;@
But when the number ends up being a negative, that's the only time I want
this to show but I'd want it to show the number (not as a negative) plus the
words "over est." (over estimate)

So, if the calc. came to -4, I'd want the cell to show "4 over est."

How can I do this?

Right now, it's reading "-4 over est." - yuck!

Thank you.

"Peo Sjoblom" wrote:

Try

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



--

Regards,

Peo Sjoblom


"Nicole L." wrote in message
...
THanks - that SHOULD work but how can I remove the negative (-)?
I think there must be some other way, some formula... like an IF, then
statement. Do you know of something like that?
Thanks

"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;@