How to read data with ‘E+’ in Excel

[sumouse (ChoboIT)]

Cells K3, Source Data : 2310031264420060
Using by Read Cell Activity or Read Range Activity : 2.31003126442006E+15

I want data : 2310031264420060

Even if I use vba, I get the same result in the end.

ThisWorkbook.Worksheets(“FILTER_DATA”).Range(“L3”).Value = “'” & ThisWorkbook.Worksheets(“FILTER_DATA”).Range(“K3”).Value

[Gokul001 (Gokul Balaji)]

Hi @sumouse

Can you try with this VBA expression?

ThisWorkbook.Worksheets("FILTER_DATA").Range("L3").Value = "'" & ThisWorkbook.Worksheets("FILTER_DATA").Range("K3").Text

Another way

You can try woith modern activity

04.10.2023_Fourm_2.xaml (8.9 KB)

Regards
Gokul

[Anil_G (Anil Gorthi)]

@sumouse

Try using Read range workbook activity and check

cheers

[Parvathy (PS Parvathy)]

Hi @sumouse

Try this VBA code:

ThisWorkbook.Worksheets("FILTER_DATA").Range("L3").Value = "'" & ThisWorkbook.Worksheets("FILTER_DATA").Range("K3").Value

Hope it helps!!

[Srini84 (Srinivas Kadamati)]

owHi @sumouse

I tried to recreate your issue but not successful, because I’m able to see the below result

Check with the Excel Application scope (both classic / modern)
If not copy the file to another file and check

Hope this may help you

Thanks,
Srini

[Yoichi]

HI,

I think it’s double type matter. Can you try to convert it Decimal as the following?

Regards,