Describe "numerical" for us. Obviously all digits meet that criteria. What
about numbers with a decimal point in them? Or a leading plus and/or minus
sign. How about with thousand's separators. Excel recognizes 1.23E+45 as
number... is this acceptable to you too? What about numbers with leading
currency symbols or trailing % symbols? Or any other variations that I might
be forgetting at the moment?

--
Rick (MVP - Excel)


"sapai" wrote in message
...
Hi,

I have a requirement wherein I need to format the sheet to accept only
numerical values. Any other data (numerical or special characters) should
be
changed to "N/A". is this possible in Excel ?

Thx
SPA