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.

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.