Is there a way to change EVERY cell in an Excel spreadsheet to "General" format in one shot in vb code? If you open the spreadsheet, you can hit CONTROL-A to select all then change it to General... is there a way to do that in code? The reason I am asking this is because I have a spreadsheet with text in it, but the cells are formatted as "Number" and when I open it with ADO, those cells become NULL in the recordset. Please help if you can!

Thanks,
Thai