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