PDA

View Full Version : Limit cell to numeric values only



av8tordude
08-06-2010, 08:49 AM
Is it possible to limit cells to numeric values only? If so, can someone offer their knowledge in providing a code that will prevent the user from entering any character that is not a number value...

Starting at row 9, prevent the user from entering any character that is NOT a number value in the following columns: E-S & U-AA

Thank you for your expertise :friends:

Bob Phillips
08-06-2010, 08:58 AM
Use Data Validation with numeric Allow option.