Questions

Formating "Excel" concatenate

Tags:
+
0 Votes
Locked

Formating "Excel" concatenate

RyNo1966
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