This is driving me nuts.

I have an HTML table, generated with ASP, in which EVERY row has valign="middle".

The ASP has the line:

Response.ContentType = "application/vnd.ms-excel"

to make the page display in Excel.

Yet the excel spreadheet that is displayed REFUSES to show the text vertically aligned to the middle in each cell. It is always bottom aligned.

What do I have to do to get my Excel cells containing text that is vertically aligned to the middle of each cell?

Please help quickly before I smash my monitor up.