I've tried this for couple hours and it's time to seek help now.
I have a big chunk of data importing from Klippel, a software that I believe
most people rarely used it.

when I use isnumber on the cells, the result is false. I have followed over
5 methods (I want automatic method so that I don't need to type in manually)
but all failed. I follow the thread he

http://support.microsoft.com/kb/181298

tried out almost all the method but have no good luck. Anyone can direct me
how to do that?

I want to attach my file here but how can I do that? Thanks...