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     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