Format cells to only accept numbers
 

How can we format and protect cells to not accept text, only numbers?

Format cells to only accept numbers
 

Hi cradino

Example for cell A1

You can try DataValidation ..Custom with this formula

=ISNUMBER(A1)



--
Regards Ron de Bruin
http://www.rondebruin.nl



"cradino" wrote in message ...
How can we format and protect cells to not accept text, only numbers?

Format cells to only accept numbers
 

data validation - numbers

"cradino" skrev:

How can we format and protect cells to not accept text, only numbers?

Format cells to only accept numbers
 

cradino,

Use data validation. Select the cells you want to apply the data
validation to. Go to DataValidation. Select Decimal or Whole number
from the Allow list then choose your minimum and maximum number and
click OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=563788

Format cells to only accept numbers
 

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563790