Mixing number formats in one cell
 

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.

Mixing number formats in one cell
 

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...

"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.

Mixing number formats in one cell
 

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

Mixing number formats in one cell
 

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.

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.

Mixing number formats in one cell
 

=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


On Wed, 18 Mar 2009 10:52:11 -0700, 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.