Export 0.00 to excel issue missing 00 after the period

See more:

C#

ASP.NET

MS-Excel

string

export

, +

I am trying to export some values to Excel. I am able to export values like 1.23, 5.45,9.25 successfully with decimal values by specifying dataFormatString = {0:N2}. But the same is not working when I export 0.00, the decimal values 00 after the period are removed . So I am just seeing '0' instead of '0.00'. Below is the code I am using Any help would be appreciated.

if (column.ColumnType == ViewColumnType.Numeric)
                {
                    var dataFormatString = "{0:N2}";
                    string rowText = string.Format(dataFormatString, "0.00");
                }

string newText = rowText.Replace("\"", "\"\"");
                    _writer.Write(string.Format("\"{0}\"", newText));

[Edit]Code block added[/Edit]