Hello,
I have to convert the column datatype in Excel to String. The column contains scientific notation. Once I used NumberFormat to convert it, the scientific notation is not expanded. Can someone help? I need code. Thanks.
Oker
This question was redirected from
Using C# to expand all scientific notation in Excel
How to convert column datatyp in excel to String using C#
@NormaW-0840
May I know whether your issue has been solved or not? If not, please share it in here. We can work together to figure it out.
Is there any difference between getting the scientific notation form and getting the ordinary number form?
We can easily convert them to each other with c#.
decimal h = Decimal.Parse( cellValue.ToString(), NumberStyles.Any, CultureInfo.InvariantCulture);
Moreover, even if it is converted to Text type, its value still is the correct number. Is it different in your case?
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
8 people are following this question.
