Hi Mark,
If you look at the format under Format, cells, custom
it should be apparent where the Red comes from.
http://www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Peo Sjoblom" wrote in message ...
Use a format like 0.00%
Regards,
Peo Sjoblom
"Mark" wrote:
Does anyone know how to stop percentages changing to red when negative?