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 [TABLE="width: 91"]
<tbody>[TR]
[TD="width: 121, bgcolor: transparent"]
8260170540706602 ---
But appears like this [TABLE="width: 91"]
<tbody>[TR]
[TD="width: 121, bgcolor: transparent, align: right"]8.26017E+15
[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

 

[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 [TABLE="width: 91"]
<tbody>[TR]
[TD="width: 121, bgcolor: transparent"]8260170540706602 ---
But appears like this [TABLE="width: 91"]
<tbody>[TR]
[TD="width: 121, bgcolor: transparent, align: right"]8.26017E+15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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.