[RESOLVED] Cells must only contain numbers

Hi once again

Can I format or use VBA to make cells only contain numbers and letters = nothing ?

Have you tried using validation?:

MenuBar > Data > Validation >

Do you want to allow only numbers to be entered or to eliminate all non-numeric data?

I want to eliminate all non-numerous data I extract from other cells :D

If Not IsNumeric() Then
....
or
If IsNumeric()
Details depend on your code.

It works with validation only...thanx!