0

I'm generating excel report in c# in excel.binding data to excel through datatable.

There is one column which will consist of 16 digit number for eg.,1317722825000285 but in excel it is coming as 1317722825000280 last digit is getting replaced by 0.

So how to can I format this column value as excel Text ?

Magicprog.fr
  • 4,072
  • 4
  • 26
  • 35
chaitra
  • 33
  • 3

1 Answers1

0

There's a great post here that may answer your question: Format an Excel column (or cell) as Text in C#?

Try formatting the cell as text and making your variable a string in C# before inserting.

Hope this helps.

Community
  • 1
  • 1
Zaberi
  • 86
  • 1
  • 7