something like:
=text(a1,"00.0%") & " Remaining"

Or if you decide you want to use that cell for further arithmetic operations,
it's nice to keep the value numeric.

You could use a custom format:
00.0%" Remaining"







Craig860 wrote:

I'm drying to build a cell in Excell that contains a mix of txt and percent
but the format get's messed up. For example what I want is:

A1=89%
B1=89% remaining. (=a1 & " remaining.")

instead what i get is "0.88554216874699 remaining." Number formats don't
have any affect.

--

Dave Peterson