Thread: Concatenate numbers and text while holding a custom number format.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Concatenate numbers and text while holding a custom number format.
Hi,

Try this

=N3&"_"&INT(O3)&"+"&MID(O3,SEARCH(".",O3,1)+1,2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jpowell111" wrote in message
...
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.

Reply With QuoteReply With Quote