=E3 &"_" & TEXT(O3,"your format")

##0+#0.00 does not return 48+29 for me but maybe you have a typo?


Gord Dibben MS Excel MVP

On Mon, 8 Feb 2010 15:18:06 -0800, jpowell111
wrote:

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.