number format when concatenating

[glad_ir]

Hello,

I wonder if somebody can help me with this one please.

I would like to combine a % value from one cell with text in a second cell but % is being converted to decimal - e.g.

cell A1 = 50%
I would like cell A2 to return "50% reduction in cost". I am using the formula below but this is giving me "0.5 reduction in cost". Is there a way to specify %?

="A1"&" reduction in cost"

Any help much appreciated!

thanks,
Iain

 

[Joe4]

Formulas only look at values, not formatting. So you have to include it in the formula by using the TEXT function, i.e.

=TEXT(A1,"0%") &" reduction in cost"

 

[Fluff]

How about

=TEXT(A1,"0%")&" reduction in cost"

 

[Dave Patton]

posted too late

 

[glad_ir]

wow! that was quick. Thank you All - much appreciated

 

[glad_ir]

Formulas only look at values, not formatting. So you have to include it in the formula by using the TEXT function, i.e.

=TEXT(A1,"0%") &" reduction in cost"

thank you for the explanation as well - very helpfiul

 

[Fluff]

Glad we could help & thanks for the feedback.