Last post Apr 03, 2017 05:48 AM by Zhi Lv - MSFT
Mar 31, 2017 12:49 PM|tadbirgaran|LINK
i have an excel file contain name and phone number and mobile number.
when i read data from excel, some of phone numbers show as e+
for example when excel cells as telephone is: 0412241596
in reading using c# , read as 4.12242e+008
how can solve problem?
Apr 01, 2017 03:29 PM|M_D|LINK
You may change the format of cell. Right click on cell, click on 'Format cells', choose NUMBER and 0 (zero) in 'Decimal places'
Apr 03, 2017 05:48 AM|Zhi Lv - MSFT|LINK
As M_D said, the issues is related to the cell format in the excel. But I suggest you change the format to "Text".