Format cells to only accept numbers

[cradino]

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

[Ron de Bruin]

Hi cradino

Example for cell A1

You can try Data>Validation ..Custom with this formula

=ISNUMBER(A1)



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



"cradino" <[email protected]> wrote in message news:[email protected]...
> How can we format and protect cells to not accept text, only numbers?

[excelent]

data validation - numbers

"cradino" skrev:

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