Crystal Reports exports data as 7.46E+11 instead of as whole number

We are using Crystal Reports v8.5.

We run a report which is fine.

We export the results in the format of TEXT and save it locally.

We then Save As a .CSV file because that is how the client we export to wants it.

When we open EXCEL, the column that contains UPC has changed from 746480000000 to 7.46E+11

If you click on a cell, it shows the whole number in the cell and the line above where you can edit it.

We need to be able to format this column correctly so that the client gets what they want.

Any ideas?
RSchiererAsked:
Who is Participating?
 
Kurt ReinhardtConnect With a Mentor Sr. Business Intelligence Consultant/ArchitectCommented:
What does the field look like in the exported text file?  Is it a whole number?  If so, you have a Microsoft problem, not a Crystal Reports problem.  Here's an article explaining it:

http://support.microsoft.com/kb/214233

Also, why are you exporting to text first, then saving as .csv?
0
 
mlmccConnect With a Mentor Commented:
Agree.

Crystal can export to CSV and even to Excel though you are probably looking for only the data rather than a report formatted spreadsheet.  CR9 added the ability to get data only.

mlmcc
0
 
peter57rConnect With a Mentor Commented:
I agree with Kurt.
I don't believe there is any way to enter such a number into an unformatted Excel cell without Excel doing such a conversion.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.