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!

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

Exporting time fields to Excel

Status
Not open for further replies.
kokomol

kokomol

Technical User
Jun 8, 2006
18
US
I am using Crystal XI and trying to export reports that contain time fields to Excel. All of the time fields show XXXXXXXXXXXXXX in them. I am a user, not a technician and I can't figure out how to make the times show up. I know that Crystal uses TimeDate fields but I don't know how to fix the Excel spreadsheet to show the time.
 
Sort by date Sort by votes
This is probably an excel situation. Just grab one of the column headers in excel for the time field and make it wider.

DataDog [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
Upvote 0 Downvote
I tried doing that and it did not work, just made more Xs appear
 
Upvote 0 Downvote
In Excel, try DOUBLE clicking the vertical line beween the column header for the time field and the next column.

DataDog [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lavadan
  • Locked
  • Question
Export to excel with drop down data
Replies
2
Views
182
hilfy
hilfy
hpl2001
  • Locked
  • Question
Fields missing in link window
Replies
1
Views
142
kray4660
kray4660
smmaruf82
  • Locked
  • Question
How to Fixed 4 Column in Crystal Report Crosstab
Replies
1
Views
172
lbass
lbass
DanEvansJr
  • Locked
  • Question
Crystal Report to Adobe pdf - font issue
Replies
1
Views
196
DanEvansJr
DanEvansJr
n2nuk
  • Locked
  • Question
Migrating reports from CR server 2013 to CR Server 2016
Replies
6
Views
303
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top