Excel: CONCATENATE or TEXT function to retain specific # formating

Hello all, I am trying to combine 2 cells to create a generic ID but I am having trouble finding the correct formula to retain the appropriate formatting. Cell D2 = 0.2500 Cell E2 = SA516-70 The desired result is 0.2500_SA516-70 I have tried =TEXT(D3,"#.####")&"_"&E3 as well as =CONCATENATE(D3,"_",E3) but neither retains the number formatting for cell D2 Any suggestions would be greatly appreciated

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of May 15, 2017.

For more resources for Microsoft Excel