Skip to Content
0
Jul 21, 2016 at 10:52 AM

File sender - How to read the excel cell correctly? Exponential values

78 Views

Hi experts,

The source file which is a csv has some phone number entries which are read as scientific exponential values (just the way it is shown in the excel sheet). For example; 1.22E+09 for 1215113944. When I open the source file it shows the exponential value, but when I click on the cell, it shows the correct value. It also shows correct value when opened using a text editor like notepad.

PI reads this file in the incorrect way and is also archiving it the same way.

Is there a way PI can read these numbers correctly?

Many thanks,

Ramesh.