Google Spreadsheet Post #1832
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov-13-2014
post by Odd Vagsmyr:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/GHYorsJ4HZQ)Only numbers in a column
How can I prevent users from typing letters in a column? Only numbers sholuld be allowd in this column. In this case (I4:I).
---
Hi, yes it worked, but what do I do if I don't want numbers, only letters, in a column? (I tried some variation but didn't make it)
---------------------------------------------------------------------------------------------------------------------------------------------------
In the following I have presented a solution for only allowing entry of Alpha (Non-Numeric) characters only
