Excel Formatting issueI am having an excel template in a shared path and loading a data in tat excel using Dot net code.
I am trying to load this data("123456789012345683968.00") into Excel via Dot net.
once the load completed data look like this ("123456789012346000000.00")
Looks like 5683968.00 last 7 digits getting rounded as 6000000.00.
Issue is in Excel template which I am having in shared path.
Someone please assist me how to format this in excel.
I have tried to format the cells as "Text" but still I am getting the same issue.