set column data type

GemBox.Spreadsheet
1

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?

2

Hi Chandler,

Try this:

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

Regards,
Mario

3

that’s works, thank you!