in reply to OT? Download to Excel number formats not working

I don't believe there are any characters I need to escape

Are you sure that in this line:

style="vnd.ms-excel.numberformat:_(* #,##0.00_)[semicolon]_(* (#,##0.0 +0)[semicolon]_(* "-"??_)[semicolon]_(@_)"

you should not escape the internal (inside the parentheses) double quotes?

Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."

Replies are listed 'Best First'.
Re^2: OT? Download to Excel number formats not working
by Lori713 (Pilgrim) on Jul 31, 2008 at 20:01 UTC
    Good suggestion. I escaped out of the double quotes with a backslash but still no go. I get a little error dialog box indicating that it doesn't like the formatting I'm trying to apply.

      If I remember well, in Excel you need to escape the double quotes doubling them. But perhaps not, it is at least 6 years since I used Excel last time...

      Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."