C
cparsons
I have a cell whose value must be 7 numeric digits and the leading zero
must be visible. When the cell is empty then I need it to be blank no
7 zeros. I tried using data validation where the text = 7 digits bu
that allowed me to enter non numeric characters. I also tried usin
data validation where the number must be between 0000001 and 999999
but that did not show the leading zeros.
Any suggestions??
Thanks
must be visible. When the cell is empty then I need it to be blank no
7 zeros. I tried using data validation where the text = 7 digits bu
that allowed me to enter non numeric characters. I also tried usin
data validation where the number must be between 0000001 and 999999
but that did not show the leading zeros.
Any suggestions??
Thanks