Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel formatting....weird problem....

Status
Not open for further replies.

NNNY

Technical User
Nov 1, 2013
6
US
Good day all,

I just encountered an unusual issue with exporting to Excel and would love to be able to find a solution for it...

In my original report, I had several fields that are numeric (or date) by nature. When exporting to Excel, they did come up as their original type with no issues....

I then had to create several groups (in order to force a sort order on the report), and used those same fields as my groups....
Now, when I export the same data to Excel, the fields are coming up as text....even though when looking at each field in Crystal, it is still labeled as number......
Any idea on how to force a group to remain a numeric value instead of forcing it into text?

Thanks in advance....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top