Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
I would like to have a 10 digit number that only includes numbers. The formula that I'm currently using will flag anything over and under 10 digits. However, it will not flag anything other than a number like text or a space. Because what this document is used for I don't want to use data validation for this project. The formula I'm currently using is =AND(ISNUMBER(--C2),LEN(C2)<>10). I'm using the not equal because if this is filled out in error I need it highlighted. Also not critical but if I can have the 10 digit number lead off with a 1, it would be fantastic.
Thank you,
Sheridan
Thank you,
Sheridan