Thank you for helping me
I need to add following data validation to excel cell
Allow user to input 8 numeric digits for eg. 12345678
Cell A1
=AND(ISNUMBER(A1),LEN(A1)=8)
My issue is with a number starting with "zero" for eg. 00012345
In this case when i enter a number starting with 00012345 excel doesn't consider zero as a number and also replaces it like 12345
How can i add a data validation of numeric 8 digits for a number that is starting with 0?
FYI - I have tried changing the number format it didn't work
Bookmarks