Mixing number formats in one cell
That worked! Thank you all!
"Ron Coderre" wrote:
Try this:
=TEXT(A1,"0%")&" remaining"
Does that help?
Regards,
Ron Coderre
Microsoft MVP (Excel)
"Craig860" wrote in message
...
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.
|