TEXT function now showing negatives in Red

Functions only return values to their cells, they cannot apply formatting.

Can you just apply the custom number format directly to the cell?

Thanks for the help - it's what I suspected.

The function is part of a bigger formula that is giving subtotals to many columns at the bottom of a report - all in one long formula string.
So, I could try and split the formulas into individual cells and format the cell, but it's not worth the trouble !

Thanks anyway.