In this tutorial, I’ll show you how to combine a custom number format and data validation to force users to enter the correct number of numeric digits.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.