excel column only numbers
 

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

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.

excel column only numbers
 

See my response to your previous post, and please only ask the question
once.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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

excel column only numbers
 

Hi Tim,
you want Validation

Validate / Validation
http://www.mvps.org/dmcritchie/excel/validation.htm

When doing Data Validation you select a range, the formulas will be
applied to the entire range based on the formula in the active cell,
which would normally be the first cell in the range.

Select Column B
Data, Validation, custom, formula is: .

your test could be
=ISNUMBER(B1)
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

excel column only numbers
 

Thanks everyone but i tried each soln and the words stay in the column?

excel column only numbers
 

Until you enter a correct value -- a number, if you hit "Retry"
you type over the selection; if you use "Cancel" button
you can start over as if you had done nothing.

When you create the validation there is additional
information that you can provide by choosing a tab
on that dialog.

What do you want to happen, perhaps you would prefer
and Event macro, where something is actually entered
if you mess up.
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tim" wrote in message ...

Thanks everyone but i tried each soln and the words stay in the column?

excel column only numbers
 

Tim wrote:
Thanks everyone but i tried each soln and the words stay in the
column?

Hi Tim
you have to apply the data -validation prior to entering data into the
cells. Applied after entering does not work. Excel will only re-check
after re-entering data in this cell

Frank

excel column only numbers
 

Tim

Data Validation prevents entry of anything but your criteria as pointed out i
other posts.

It will not delete/clear previously entered items.

That will have to be done manually or through VBA.

Gord Dibben Excel MVP

On Thu, 5 Feb 2004 12:16:09 -0800, Tim
wrote:


Thanks everyone but i tried each soln and the words stay in the column?

excel column only numbers
 

To identify cells in Column B that are not numbers you can use
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Select Column B with cell B1 as the active cell
Format, Conditional Formatting, formula is:
=AND(ROW()<1,ISTEXT(B1)
choose format, use patterns tab to supply a background color
such as a pastel color.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gord Dibben" <gorddibbATshawDOTca wrote
Data Validation prevents entry of anything but your criteria
as pointed out in the other posts.

It will not delete/clear previously entered items.

That will have to be done manually or through VBA.