Skip to Content
author's profile photo
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Oct 11, 2007 at 02:17 PM

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

    Add comment
    10|10000 characters needed characters exceeded