CONCATENATE or TEXT function to retain specific # formating

[TDC21]

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

 

[kelly mort]

There is no time like the present! In my experience, helping others has been a great way to learn new tricks and build on prior knowledge/skills.

Yes i am helping them but most often i get limited knowledge. So with time i will acquire more knowledge when i can help the most. Thanks