The Definitive Guide to Data Quality
With the build-in Excel component you cannot format the cells.
The data type of the schema column defined the kind of cell in Excel.
If you need an additional format option (like the number or date format) you could use the Custom component tFileExcelSheetOutput (+tFileExcelWorkbookOpen). This component allows to set additional format pattern like #,##0.#