QTP reads the Excel cell format differently during
I have noticed that the cell format of the Excel spreadsheet gets changed when I inserted a new column.
Actually when I opened up the Excel file and look into the cell format, it is unchanged, but during the runtime QTP reads it differently. For example date format got changed to number and vice versa.
This is actually not happening to all the cells, but only to some of the cells. Has anybody encounters this type of problem and got the global solution? I don't want to go back to each ceall or column and change the whole format. Even by doing that, it sometimes worked, sometimes did not. I would appreciate any kind of help.