Display Format with Text & Formula
 

I have the following formula:
="Post-Judgment: "&IF(I8=0,0,(H8/I8))&" %"
that displays as "Post-Judgment: 0.833333333333333 %"
Is it possible to force it to display as
"Post-Judgment 83%".

I've tried formatting the cell to "percentage" but that doesn't work with
the text displayed.

Hi Stephanie

try

="Post-Judgment: "&IF(I8=0,0,TEXT((H8/I8),"##%"))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"StephanieH" wrote in message
...
I have the following formula:
="Post-Judgment: "&IF(I8=0,0,(H8/I8))&" %"
that displays as "Post-Judgment: 0.833333333333333 %"
Is it possible to force it to display as
"Post-Judgment 83%".

I've tried formatting the cell to "percentage" but that doesn't work with
the text displayed.

YAY. Thanks Julie.

"JulieD" wrote:

Hi Stephanie

try

="Post-Judgment: "&IF(I8=0,0,TEXT((H8/I8),"##%"))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"StephanieH" wrote in message
...
I have the following formula:
="Post-Judgment: "&IF(I8=0,0,(H8/I8))&" %"
that displays as "Post-Judgment: 0.833333333333333 %"
Is it possible to force it to display as
"Post-Judgment 83%".

I've tried formatting the cell to "percentage" but that doesn't work with
the text displayed.

you're welcome
--
Cheers
JulieD

"StephanieH" wrote in message
...
YAY. Thanks Julie.

"JulieD" wrote:

Hi Stephanie

try

="Post-Judgment: "&IF(I8=0,0,TEXT((H8/I8),"##%"))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"StephanieH" wrote in message
...
I have the following formula:
="Post-Judgment: "&IF(I8=0,0,(H8/I8))&" %"
that displays as "Post-Judgment: 0.833333333333333 %"
Is it possible to force it to display as
"Post-Judgment 83%".

I've tried formatting the cell to "percentage" but that doesn't work
with
the text displayed.