Keep same format

[Excelski]

Hi,

I am using ="Currently"&" "&B34&" "&"Complete"
B34 is 50% but is returned in the above as 0.5

How can I keep the same format ie 50%

Thanks
Kevin

[AliGW]

Maybe this?

="Currently"&" "&B34*100&"% "&"Complete"

[Excelski]

Of course!!!
Thank you
Kevin

[Sam Capricci]

add text to it like this...
="Currently "&text(B34,"0%")&" Complete"
and you can consolidate the spaces into the other text areas.

[modytrane]

="Currently " & B34*100 & "% Complete"