Changing to number from scientific notation

[psjoyce]

Hello
I receive files with account numbers that come to me in scientific notation. the file is already a CSV. Can i change the scientific notation value back to its original number? An example is below
This is one of those annoying problems that is putting a project at risk - believe it or not. Thank you very much in advance

Original account number

8260170540706602 --- But appears like this 8.26017E+15 <tbody> </tbody>

<tbody>
</tbody>

 

[Rick Rothstein]

Hello
I receive files with account numbers that come to me in scientific notation. the file is already a CSV. Can i change the scientific notation value back to its original number? An example is below
This is one of those annoying problems that is putting a project at risk - believe it or not. Thank you very much in advance

Original account number

8260170540706602 --- But appears like this 8.26017E+15 <tbody> </tbody>

<tbody>
</tbody>

Are you saying the CSV file contains 8.25017E+15 in it? If so, then I am pretty sure the rest of the digits are gone. The problem is the source where the CSV file was created from kept the account number as a numeric value, hence the conversion as 16 digits were too many to store as a number. I am guessing that if the original file stored the account number as text, it would have survived in tact when the CSV file was created.

 

[psjoyce]

Thank you for your prompt reply. Yes the original file has the 8.25017E+15. . Despite my repeated attempts to get the programmers to change the reporting logic/code. However, I will provide the explanation you provided as to why this is happening to help them understand that they need to save that field as a text field.