G
Gmonny
I'm trying to use a numeric value with a leading zero, but the format keeps
dropping the leading zero. I've tried custom formatting, but it also drops
the lead zero. The only way to display the leading zero is to format the
value to text, but then it places the text tag in the cell, which I don't
want. Is there a way to format a cell to allow leading zeros without
converting or formatting the value as text?
dropping the leading zero. I've tried custom formatting, but it also drops
the lead zero. The only way to display the leading zero is to format the
value to text, but then it places the text tag in the cell, which I don't
want. Is there a way to format a cell to allow leading zeros without
converting or formatting the value as text?