=TEXT(A1,"0.0%")&... the rest

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Hi,
I have a problem in a concatanating formula. my text is pretty simple,
with
this, i have added a value from a cell. This is a percentage figure (25%).
Only, it looks like this 25.04568472367376574%. I have formatted the cell
to
1 decimal point but can this be done for the concatanating formula?


Regards,

Nigel