Hello,

Please follow the steps bellow:
1- Right click on the cell where you have placed the formula;
2- A vertical menu will appear, then click where says "Format Cells"
3- When Excel displays the Format cell dialog box, click number tab and then
select the category you want to use(number or currency)
4- Select the 1234.10 if you choose number or select $1,234.10; if you
choose currency.

I hope it helped.
Regards,

JMiller

"Nobody" wrote:

I currently have a formula or function which is =SUM(B26-B17) what do I
add if I want the total to appear in red if it is a minus rather that a
positive

Thanks