Date format instead of numbers when uploading to an excel file

[Former Member]

Hi all.

I am using the FM 'Z_BG_DOWNLOAD' for uploading an internal table to an excel file. one of the fields in the internal table is of the type char50.

when the excel file is been created, all the records in this field that looks like a date format, convert themselves to an actual date (in the excel sheet).

for example: a field that looks like this: 02-08/04 (which is not a date and i want it to stay like this) becomes like this format:02/08/2004.

How can i prevent it to become in a date format?

Thanks.

[rainer_hbenthal]

include your values in " or put an apostrophe i front of them preventing excel to interpret your data.