change of format when transferring string from C# to Excel

I have a problem when I want transfer data from dataGridView in C# to Excel.

My data was "84853435455002" and wh开发者_高级运维en I saved in Excel I see this format "8.675675E2".

I want to save my data completely and not have "E" in my data .. what must I do to solve this .

---

You need to format your cells in Excel to Number and set any decimal places to 0 if you do not want decimal too. By default the Excel cell format is general which converts your input this way.

---

u have to tell excel to read the cell as text. Or add some special character to numbers, so excel will read it as text. eg. " '84853435455002 " (put single quote in front of number)