Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date format instead of numbers when uploading to an excel file

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.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question