Refer your previous post for responses from Mike and Joel..

You can handle that in your code using functions like Val() IsNumeric() etc;

If this post helps click Yes
---------------
Jacob Skaria


"Yuvaraj Mani" wrote:

I have a Macro which imports the data from the excel 2007 and create a new
formatted excel 2007 Report file .

When importing the data from the input excel file, in certain machine the
number imported from the input text file was taken as string and throws 'type
mismatch' error also I found that I have to use different option to go to
debug mode.

Please let me know is there any option available to make number to be number
instead of text .So that the error would not occur