"Kash" schrieb im Newsbeitrag
...
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.


Hmm,

I assume your localized version of Excel is using the comma as
decimal sign, right?
Then how about negative values?

BTW, the suggested IsNumeric will accept values like
"543E12" or "120D4" as numeric if used in VBA.
The Excel spreadsheet function with the same name however
will return False in the second case (tested with Excel 97).
Excel will recognize it as a number if I enter 123E4 into a
cell and automatically convert it to 1.23E+06 (=1230000)
using scientific notation. 123D4 however is treated as
text and not recognized as scientific notation.

Helmut.