Formula help

[James_clare]

=“generic text”&sheet1!A1&”generic text” Say if it was a percentage figure in cell A1 sheet 1, when I do the above line, it pulls it through as a whole number and not a percentage, how would I change that line to pull through it as a percentage?

[#2]

@James_clare 

If it really is a whole number then it would have been 100%, 200%, 300%, etc.

So this would be sufficient:

=“generic text”&sheet1!A1&”00% generic text” 

[#3]

Thanks for your reply, I’ll test that out at work tomorrow when I get there and let you know if it fixes it, thank you

[#4]

@James_clare -

Or even possibly you could write as:

="Generic Text " &TEXT(A1,"#.0%")&" Generic Text 2"

Producing: