How to Allow Input Number and Text Only in Excel with Data Validation(Video in Khmer)

Hello everyone! Today I show you how to allow input number and text only in Excel step by step with simple examples and video in khmer.

You ever have problem where someone type wrong thing in your Excel? Like they put text in the number column, or put number where suppose to be name? Very annoying right? Don't worry, Excel have feature call Data Validation that can fix this problem easy.

What is Data Validation? — Data Validation is like a security guard for your cell. You tell Excel "this cell only accept number" or "this cell only accept text", and if someone try type wrong thing, Excel will show error message and block it. Very useful when you share file with other people.

In this post I show you two method — one for number only, one for text only. Watch video below, I explain everything in Khmer.

1. How to Allow Input Number Only in Excel

First method is make cell accept number only. You go to Data tab, click Data Validation, then choose "Whole number" or "Decimal" from the list. After that, if someone try type letter like "abc" in that cell, Excel will say no. Very easy to set up, take only 30 second.

2. How to Allow Input Text Only in Excel

Second method is make cell accept text only. This one little bit tricky because Excel don't have "text only" option direct. But you can use Custom formula in Data Validation like =ISTEXT(A1) to check. If someone type number, Excel will reject it. I show you exactly how in the video below.

💡 You can also add Input Message and Error Alert in Data Validation setting. Input Message show small popup when user click on the cell, tell them what to type. Error Alert show warning when they type wrong thing. This make your spreadsheet look very professional!

📚 Useful Resources

• Top Microsoft Excel Tips and Tricks Every Spreadsheet User Should Know
• Essential Excel Keyboard Shortcuts Every User Should Know
• How to Count and Find Unique Values in Excel
• How to Highlight Data in Excel Step by Step
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)