Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixing text and formulas in the same cell | Excel Discussion (Misc queries) | |||
How do I determine the number of cell formats in this workbook | Excel Discussion (Misc queries) | |||
mixing text and formulae in same cell | Excel Worksheet Functions | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
Mixing Font Sizes In A Cell Formula | Excel Worksheet Functions |