Auto conversion of the Text to Number Getting Failed in Excel 2007
 

Auto Conversion of Text to Number is getting failed in excel 2007:

Number values from the Spreadsheet formatted as Text instead of Number that
leads to Type mismatch error in VBA Program.

How to auto convert the Number values in the excel cells to Number instead
of Text

Auto conversion of the Text to Number Getting Failed in Excel 2007
 

Post the code


"Yuvaraj Mani" wrote:

Auto Conversion of Text to Number is getting failed in excel 2007:

Number values from the Spreadsheet formatted as Text instead of Number that
leads to Type mismatch error in VBA Program.

How to auto convert the Number values in the excel cells to Number instead
of Text

Auto conversion of the Text to Number Getting Failed in Excel 2007
 

MyNum = trim(Range("A1"))
if not Isnumeric(MyNum) then
MyNum = Val(MyNum)
end if


"Yuvaraj Mani" wrote:

Auto Conversion of Text to Number is getting failed in excel 2007:

Number values from the Spreadsheet formatted as Text instead of Number that
leads to Type mismatch error in VBA Program.

How to auto convert the Number values in the excel cells to Number instead
of Text