How to convert the scientific notation to numbers for a row item under for each?

[kit2815]

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?

[gabrielribas4 (Gabriel Ribas)]

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!!

[kit2815]

Hi @gabrielribas4

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.

[gabrielribas4 (Gabriel Ribas)]

@gabrielribas4

Decimal.Parse("2.42E+13",System.Globalization.NumberStyles.Any)

Decimal.Parse(row.Item("Bank Acct No").ToString,System.Globalization.NumberStyles.Any)

Make sure that you are getting the expected Output!

[kit2815]

@gabrielribas4

Decimal.Parse(row.Item("Bank Acct No").ToString,System.Globalization.NumberStyles.Any)

Thanks Gabriel!!!