C
cradino
How can we format and protect cells to not accept text, only numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
Hi cradino
Example for cell A1
You can try Data>Validation ..Custom with this formula
=ISNUMBER(A1)
Example for cell A1
You can try Data>Validation ..Custom with this formula
=ISNUMBER(A1)
E
excelent
data validation - numbers
"cradino" skrev:
"cradino" skrev:
S
SteveG
cradino,
Use data validation. Select the cells you want to apply the data
validation to. Go to Data>Validation. Select Decimal or Whole number
from the Allow list then choose your minimum and maximum number and
click OK.
HTH
Steve
Use data validation. Select the cells you want to apply the data
validation to. Go to Data>Validation. Select Decimal or Whole number
from the Allow list then choose your minimum and maximum number and
click OK.
HTH
Steve
V
VBA Noob
Hi,
You could use Data Validation.
Go to Data > Data Validation then select custom and insert this
formula
=ISNUMBER(E10:J19).....Change range as required.
You can also put instructions to the user in Input message and error
messages when they try to enter non numbers
This link should help
http://www.contextures.com/xlDataVal01.html
VBA Noob
You could use Data Validation.
Go to Data > Data Validation then select custom and insert this
formula
=ISNUMBER(E10:J19).....Change range as required.
You can also put instructions to the user in Input message and error
messages when they try to enter non numbers
This link should help
http://www.contextures.com/xlDataVal01.html
VBA Noob