ALV Editable Fields to XLS file

[Former Member]

Hi,

I've got this problem whereby 3 columns of my ALV that stores the date value.

This 3 editable date fields when export to EXCEL file, the date format changes from DD/MM/YYYY to YYYY-MM-DD.

Why is it so and how can i change the date format back to DD/MM/YYYY ???

Thanks a lot

[Former Member]

do not tie the editable fields to any reference