Thread: Stop % in red
View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

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?