All of a sudden all my reports and any new reports that I create don't export to excel correctly if they contain a time field. When I export to excel and the report contains a time field the cell in excel just appears as ############################ for ever regardless of the format of the time field and the width of the column. It happened all of a sudden and is effecting all reports so it must be a setting in excel or crystal. If you look in the menu/formula bar for a particular cell a number is there for example 4292554801 but the cell just contains ###########. My guess is that the time value from crystal becomes this large number 4292554801 (for example) but keeps the format so excel tries to convert this number to a time but can't because it is too big. What on earth is going on here. It must be a setting but I can't think of anything I have changed. Really weird.
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem exporting to Excel
- Thread starter Rhaegar
- Start date
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question