Read excel number in scientific format and convert to decimal

Gauri_Rawool · March 11, 2020, 9:24am

111802202000002 getting captured as 1.11802202000002 in excel.

Srini84 · March 11, 2020, 9:53am

Check below screen

Hope this helps

Thanks

Gauri_Rawool · March 11, 2020, 10:00am

this my excel file i want to convert all data from column D

Srini84 · March 11, 2020, 10:02am

I don’t see any data in your excel, also let me know have you tried with the screen i provided?

Thanks

Gauri_Rawool · March 11, 2020, 10:05am

it is only working for single value

Gauri_Rawool · March 11, 2020, 10:13am

Srini84 · March 11, 2020, 10:22am

I am able to get entire rows values

If it is getting problem for you

then use Workbook → Read Range activity

and try

Hope this helps

Thanks

Gauri_Rawool · March 12, 2020, 6:11am

Thanks a lott…chears

system · March 15, 2020, 6:11am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.