NJ1000Copper ContributorApr 09, 2020SolvedNot allow a character to be imputed in a cellHow 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?
3 RepliesReplies sorted by NewestgyankoshBrass ContributorApr 09, 2020NJ1000 you can refer here for a write up on data validationhttps://gyankosh.net/msexcel/what-is-data-validation-in-excel/ mathetesSilver ContributorApr 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? NJ1000Copper Contributor to mathetesApr 09, 2020mathetes Thank you!
gyankoshBrass ContributorApr 09, 2020NJ1000 you can refer here for a write up on data validationhttps://gyankosh.net/msexcel/what-is-data-validation-in-excel/
mathetesSilver ContributorApr 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?
