Thursday, November 13, 2014

yogi_Data Validation For Entries In Column C To Not Allow Any Numeric Characters

                 Google Spreadsheet   Post  #1832
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov-13-2014
post by  Odd Vagsmyr:
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