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.

Ultimately, Excel expects you to enter text, numbers, formulas, or mathematical symbols only into its cells, so you should avoid inserting anything else—including currency symbols.