Formating "Excel" concatenate

I am trying to find a way to format the concatenate command in Excel
I want to remove the leading zero infront of the decimal point 0.834 to show .834.

I also would like to do the same in a string. Format ="Z"&D2 where
D2 = .937 it keeps adding the zero to the whole number place Z0.937 I need it to read Z.937.

Thank You
Ryan