data validation

  • Thread starter Thread starter cparsons
  • Start date Start date
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
 
Hi

i would use data validation to ensure that people only entered numbers (max
of 9999999) and custom formatting to format the cell to show the leading
zeros (right mouse click on cell choose format cell, number tab - click on
custom and type 0000000)

hope this helps
cheers
JulieD
 
Back
Top