For all these odd formatting issues in Excel, I've always found it useful to actually create the format in an excel spreadsheet first and then read that data with perl to see how it should be generated.