ALV report export error

[Former Member]

When I am exporting the data from an ALV report to excel, date 17:07:2009 is displaying as "0.736446759" and 21:07:2009 as "0.903113426" in excel file.

If anybody has faced such problem, please help.

[Former Member]

Hi,

Just want to know the data type of these 2 fields in the internal table.

If it is not char convert into char type field and then download.

With Regards,

Sumodh.P

[Former Member]

Hi,

Just want to know the data type of these 2 fields in the internal table.

If it is not char convert into char type field and then download.

With Regards,

Sumodh.P

[Former Member]

Char type is same for all the dates.But in report say out of 100 dates only 2 or 3 dates, it is showing wrong.Also if instead of excel if I export the data in some other format, Same dates are apperaing correct.

[OttoGold]

Read: Happy reporting with Excel III: There and back and especially two previous parts (about "printing" Excels/ output)

/people/otto.gold/blog/2010/06/23/happy-reporting-with-excel-iii-there-and-back

Otto