See attached. This code generates an Excel Spreadsheet on a web server. Works beautifully.
Except for a few formatting issues.
Note the column with content <td align="left"><? print $hrmn; ?></td> and the next one. These are hhmm in military time.
The customer wants there to be leading zeros on the hour if the hour is less than 10. I have tried a lot of approaches, but when the sheet is opened in Excel, Excel of course throws out the leading zeros.
I can't see a way to trick Excel into thinking the column is text.
How can I fix this?