| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Result of a Formula Combining Text & Numbers
Trying to create a formula that concatenates text and an calculated
percentage. =CONCATENATE("Percent Change"," = ",(ROUND(((E$28-B$28)/B$28),2))) I want the result to output: Percent Change = 1.0% not Percent Change = 0.01 How do I get the calculated percentage to show as a percent? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text and formula | Excel Discussion (Misc queries) | |||
| combining numbers and text | Excel Worksheet Functions | |||
| How do I convert formula result into numbers so I can sum results? | Excel Discussion (Misc queries) | |||
| combining text and numbers in a string | Excel Worksheet Functions | |||
| Combining Text and numbers from two cells | Excel Discussion (Misc queries) | |||
Threaded Mode
