set column data type

hi, i’m converting html to excel, one cell will show number as 1.23457E+13, i want to set this column as string format, how can i do that.

I know how to set column format as date time, <td style=““mso-number-format:MM/dd/yyyy””>{0}
how to set as string?

Hi Chandler,

Try this:

<td style='mso-number-format:@'>{0}</td>


that’s works, thank you!