Hi guys!
I am now having a row item with all exponentials like 2.42E+13. I want to convert them to numbers to check the number of digits within a range under a row item in for each activity.
Would anyone suggest some ideas on how to achieve the result, please?
Hey @kit2815 !!!
Try using the follow!
Decimal.Parse("2.42E+13",System.Globalization.NumberStyles.Any)
Output: 24200000000000
Let me know if it is the correct Output! Hope it helps!!
Many thanks for your reply.
May I know is it also applicable to a row item under for each?
Because I want to convert the whole Column called “Bank Acct No” in a datatable to numbers.
Decimal.Parse(row.Item("Bank Acct No").ToString,System.Globalization.NumberStyles.Any)
Make sure that you are getting the expected Output!
Thanks Gabriel!!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.