| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using & function
=a1&" "&text(b1,"0.00%")
or ="YourTextHere " & text(b1,"0.00%") Roger on Excel wrote: I want to transpose two cells into one whereby I have a text vaue "text" and a percentage - eg 50%. In the adjacent cell i want to produce text&" "&50%, to come out as text 50%. However but it comes out as text 0.5 Is there a way to make excel display exactly what i want rather than it converting the percentage number into a decimal? Thanks, Roger -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
