Read excel number in scientific format and convert to decimal

111802202000002 getting captured as 1.11802202000002 in excel.

Hi @Gauri_Rawool

Check below screen

Hope this helps



SCBbankconsolidated.xlsx (8.4 KB)

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


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


it is only working for single value

SCBbankconsolidated.xlsx (8.9 KB)


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 a lott…chears

1 Like

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