| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text Function with Different Formatting for Number
I'm trying to use a text function where I reference a number from another
cell but I need the text part to be bold and the number not to be bold. This is the formula I'm using right now: ="Sales: "&TEXT(A16,"$#,##0_);($#,##0)") Unfortunately, excel won't let me just make the text bold without making the number bold. Anyone have any suggestions? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting result of Index function | Excel Worksheet Functions | |||
| Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
| UPPER text function | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
