Format cell as Text

[Kjell Ek]

Now I enter sheet.UsedRange(SluttidFormat).NumberFormat = "hh:mm:ss" to format a cell when exporting to Excel and it gives me this format in Excel. (see attached image)

How do I get the text format in my Excel file when exporting (at the arrow in the picture)?

I Try sheet.UsedRange(SluttidFormat).Text = "" but it not work....

I use asp.net vb and Syncfusion.XlsIO version 16.4460.0.42

Attachment: dump_c58efb84.png

[Vinothkumar Sampath]

Hi Kjell Ek,

We have reviewed your query and identified that you are using Swedish localization. Based on the Swedish culture, "hh:mm:ss" is displayed as "tt:mm:ss" ( t represents hour in Swedish). If the exported excel file is opened with English culture, the number format is shown as "hh:mm:ss". This is expected behavior.

Regards,
Vinothkumar Sampath.