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

Thanks

2 Likes

SCBbankconsolidated.xlsx (8.4 KB)

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

@Gauri_Rawool

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

Thanks

it is only working for single value

SCBbankconsolidated.xlsx (8.9 KB)

@Gauri_Rawool

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

Thanks a lott…chears

1 Like

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