Thread: Just the numbers please...........
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Just the numbers please...........
Hi

Select D1:D10 for example

DataValidation
Choose custom
=ISNUMBER(D1)



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


wrote in message oups.com...
I want the user to only be able to put numbers in a cell. Is there a
OnExit data validation I can put on the cell?

Thanks in advance,
Laura



Reply With QuoteReply With Quote