| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
