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_…

How to read data with ‘E+’ in Excel

Yoichi (Yoichi) October 4, 2023, 6:45am 6

HI,

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

Regards,

Get the exact large number from the excel file

Topic		Replies	Views
How to remove E+ value in excel column Academy Feedback	8	1947	May 18, 2019
Reading values form excel (using workbook read range) but the value is comming as exponential, need to perform normal arithmetic operations on the values Help studio	9	1422	September 7, 2019
Excelで書き出すときに、末尾のE+数字が指数に変換されるフォーラム datatable , activities , studio	5	6760	February 1, 2019
Read excel number in scientific format and convert to decimal Studio excel , activities , question , data_manipulation	8	2919	March 15, 2020
Data is read from excel as '####' Help	5	1349	August 6, 2019