Thread: excel column only numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default excel column only numbers
Hi Tim
select the column and goto 'Data Validation' and choose 'Number'

HTH
Frank


Tim wrote:
I am trying to set a column to have only numbers and reject or spit
out anything else.


Reply With QuoteReply With Quote