Although I'm not familair with the Excel object libarary, I am familiar with
VBA. How can I format the whole sheet to use Text as the cell formatting, as
opposed to General, the default?

Me.Cells.Format...?

Thanks,

Steve