Not allow a character to be imputed in a cell

[NJ1000]

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

[#2 · Accepted 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?

[#3]

@mathetes Thank you!

[#4]

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

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