| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
Linear Mode
