Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
120
Cell FormatString changes in Excel
posted

In my code I use (v11.2)

worksheet.Rows(rowIndex).Cells(columnIndex).CellFormat.FormatString = "# ##0,00"

But when open the resulting file in Excel the cell is not formatted properly and when I look at the cell properties in Excel in the Format Cells dialog I see the following : "#\ ## 000"

What should I use as the format string to get the correct "# ##0,00" also in Excel?

 

Parents Reply Children