Mixing number formats in one cell

[Craig860]

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.

 

[Sheeloo]

Format the cell as Custom with the format string as
0% "Remaining"

or use the formula
=TEXT(A1,"0%") & " Remaining"

but in this cell will have text and you won't be able to perform any
calculations...

 

[Dave Peterson]

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"

 

[Ron Coderre]

Try this:
=TEXT(A1,"0%")&" remaining"

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

 

[Craig860]

That worked! Thank you all!

Try this:
=TEXT(A1,"0%")&" remaining"

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

 

[Gord Dibben]

=TEXT(A1,"00.0%")&" remaining"

Or just Custom Format B1 to 0.00%" remaining" and don't bother with the
TEXT function

That way the number 89 will still be a number.


Gord Dibben MS Excel MVP