I have Following Query for EasyXLS for VB 6

I have a Value in Numeric which is already in formatted format.

for Eg.
"123.00"
"12,345.00"
"1,234,56789.00"

If I am using format as "numeric" then it gives the Error while opening the Excel

If I am using format as "automatic" then it does not gives the Error but it does not Show it Properly and it is Left alignment and it is String Format.

I want the same to be Numeric Format in Excel.

I am attaching the VB6 Source Code and Excel Files

Can You Help me to correct the above Code or give the Sample code to do AutoFit of the all the column ?

Thanking You,

Bhavesh

Error in "automatic" format Issue

The numbers must be entered with no additional formatting like 1,000.00, 1.000,00 or $1000.
Also 1,234,56789.00 is not a number.