concatenate with a format?

[RGH]

I'm trying to concatenate a cell that has a formula, with the text "of standard." The formula is a percent format that changes weekly and the text "of standard" is fixed.

However, when i write the concatenate formula, it drops the % format of the formula cell, so that what was 100.2% becomes 1.0002.

So basically,
This is the result i'm getting, "1.0002 of standard"
This is what I want "100.2% of standard"

Is there a way to get concatenate to use the format from the formula cell, or is there another way around this?

Rob

 

[Oorang]

EDIT:

Might be better to leave it as a percent, so you can still interact with it. Try turning it back into a straight percentage, right clicking on the cell, and going to custom formatting and enter this:

0.00% "of standard"

Here is an excerpt form the help file that might be usefull:

Displaying both text and numbers To display both text and numbers in a cell, enclose the text characters in double quotation marks (" ") or precede a single character with a backslash (\). Include the characters in the appropriate section of the format codes. For example, type the format $0.00" Surplus";$-0.00" Shortage" to display a positive amount as "$125.74 Surplus" and a negative amount as "$-125.74 Shortage." The following characters are displayed without the use of quotation marks: $ - + / ( ) : ! ^ & ' (left single quotation mark) ' (right single quotation mark) ~ { } = < > and the space character.

 

[Norie]

Rob

Try something like this

=TEXT(A1, "0.0%") &" of standard"

 

[NBVC]

=(A1*100&"%"&.....)

 

[RGH]

Thanks Norie, I tried your formula and it worked. Thanks for the other replies too, I will try them out as well.

Rob