Format text string
 

I like to combine cell values within text on my reports, usually no issues
I would like to format a number so that if it is negative it is red & in
brackets
The brackets appear fine, but I cannot change the font colour
=TEXT(ROUNDUP(I8*10.764,-2),"#,##0;[RED](#,##0)")&" ft²")
Anybody able to help?

Saintsman

Format text string
 

Hi Saintsman,

You could use:
=ROUNDUP(I8*10.764,-2)
with a custom number format:
#,##0ft²;[Red](#,##0ft²)

The advantage of doing it this way is that the result of your calculation remains numeric, despite the addition of the 'ft²'.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Saintsman" wrote in message ...
I like to combine cell values within text on my reports, usually no issues
I would like to format a number so that if it is negative it is red & in
brackets
The brackets appear fine, but I cannot change the font colour
=TEXT(ROUNDUP(I8*10.764,-2),"#,##0;[RED](#,##0)")&" ft²")
Anybody able to help?

Saintsman

Format text string
 

Thanks very much - a bit of lateral thinking.

"Saintsman" wrote:

I like to combine cell values within text on my reports, usually no issues
I would like to format a number so that if it is negative it is red & in
brackets
The brackets appear fine, but I cannot change the font colour
=TEXT(ROUNDUP(I8*10.764,-2),"#,##0;[RED](#,##0)")&" ft²")
Anybody able to help?

Saintsman