Formating "Excel" concatenate

By 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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums