| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate numbers and text while holding a custom number format.
I want to join the values of two cells with different formatting. Example:
"E3" = NPL and "O3" is a number 48.29548562458 formatted to appear 48+29. I want to come up with "NPL_48+29" but can't seem to concatenate the cells without losing the format. All I can get is: "NPL_48.29548562458" How do I get the format "##0+#0.00" to carry over? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom number format code using letters and numbers | Excel Worksheet Functions | |||
| custom format cell with text and numbers | Excel Discussion (Misc queries) | |||
| Custom number format codes for negative numbers | Excel Discussion (Misc queries) | |||
| Custom Number Format Text | Excel Discussion (Misc queries) | |||
| How to format text and numbers as custom | Excel Discussion (Misc queries) | |||
Threaded Mode
