id="info"

Question

Locked

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
Ryan

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums