I guess the OP lives in a country that uses the comma as decimal sign.
Because ISNUMERIC is localized it will happyly accept a comma in
such a locale but will return false if there is a point!

Helmut.

"ozgrid.com" schrieb im Newsbeitrag
...
If the cells actually contain a comma they will be NON numeric no matter how
numbers are in it.

--
Regards
Dave Hawley
www.ozgrid.com


"Kash" wrote in message
...
Can anyone help with a formula/macro to check if a cell contains all numeric
characters only? in which only "," can be allowed and not even a space.