View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jennifer
 
Posts: n/a
Default Validation rule - custom 5 digits w/ leading zeroes

I am having trouble creating a validation rule for cells. I would like only
6 digit numbers to be entered. However, when using CUSTOM (000000) I can't
seem to get it to work. Any thoughts?

012345
234567

It works for 234567 but not for 012345