I am using C++ Builder 2010, running under XP. (I am a registered user of the component pack.)
I still have been unable to resolve the problem. I set ExportCellFormat to False and am still getting the values in Excel in string format. I tried to use a Format.Format = "####.##" and still got a string output. I am using the same ExcelIO component with a different grid and am getting numeric output. What could the difference be between the grids?
I can't reproduce this. Are you sure the data in grid cells is strictly numeric? Did you check differences in TAdvGridExcelIO property settings? If a problem persists, please contact support by email with a full source project with which we can reproduce the problem.