M Mike H Apr 16, 2008 #2 I'm not aware of any way of doing it with a formula but it can be done with custom formatting Format|Cells|Custom #,##0%;[Red]-#,##0% Mike
I'm not aware of any way of doing it with a formula but it can be done with custom formatting Format|Cells|Custom #,##0%;[Red]-#,##0% Mike