SOLVED

Not allow a character to be imputed in a cell

Highlighted
Occasional Contributor

How do I create a formula for a cell to not allow the character -> period ( . )?

 

3 Replies
Highlighted
Best Response confirmed by NJ1000 (Occasional Contributor)
Solution

@NJ1000 

 

Use a Data Validation rule as shown below. This prevents a number with a decimal or a word or two with a period in it. Is that what you want?

mathetes_0-1586444626483.png

 

Highlighted
Highlighted

@NJ1000  you can refer here for a write up on data validation

https://gyankosh.net/msexcel/what-is-data-validation-in-excel/