When I run a query in PeopleSoft I have the option of opening it as a run to HTML file (which results in a .csv file) or as run to an Excel file. The issue is that when it is opened in HTML certain numbers populated as 337E000159 (1st part is a product number "337E0" and the 2nd part is a project number "00159") get changed to scientific numbers such as 3.37E+161 The issue may be with the"7E0" part of the number. Excel may not like this for some reason.
Here is how they show up in the query:
Column A Column B
"42378 3.37E+161 (as HTML)"
"000000000042378 337E000159 (as EXCEL)"
As you can see there is a two digit difference between 159 and 161.
When I try to change the scientific number to general or text it does not change. It remains the same. I've tried all the tricks to change it to text format but won't work.
Can anyone suggest a solution?
Let me know if more information is needed.