NJ1000Copper ContributorApr 09, 2020SolvedNot allow a character to be imputed in a cell How do I create a formula for a cell to not allow the character -> period ( . )? mathetesApr 09, 2020NJ1000 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?
mathetesApr 09, 2020NJ1000 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?
mathetesApr 09, 2020NJ1000 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?
gyankoshBrass ContributorApr 09, 2020NJ1000 you can refer here for a write up on data validationhttps://gyankosh.net/msexcel/what-is-data-validation-in-excel/
