Read excel number in scientific format and convert to decimal

[Gauri_Rawool]

111802202000002 getting captured as 1.11802202000002 in excel.

[Srini84 (Srinivas Kadamati)]

@Gauri_Rawool

111802202000002

Hi @Gauri_Rawool

Check below screen

Hope this helps

Thanks

[Gauri_Rawool]

SCBbankconsolidated.xlsx (8.4 KB)

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

[Srini84 (Srinivas Kadamati)]

@Gauri_Rawool

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

Thanks

[Gauri_Rawool]

it is only working for single value

[Gauri_Rawool]

SCBbankconsolidated.xlsx (8.9 KB)

[Srini84 (Srinivas Kadamati)]

@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

[Gauri_Rawool]

Thanks a lott…chears