Problem while downloading data to Excel

[Former Member]

Hi,

We are using downloading functionality in our program. First field is Material Number.

When we have downloaded the data to excel sheet, some of the material numbers are getting converted to DATE format.

Example: 8-2210 is been shown as Aug-10

This is creating a problem when the data is viewed in an excel sheet.

Please help me out in this regard.

Regards,

Ramesh

[GauthamV]

hi ,

these kind of problems r happened due to some of excel settings.

it has nothing to do with abap.

if u check in some other system it might be right.

otherwise define ur fields in final internal table based on reference table and fieldname .

[Former Member]

Hello

Please convert all the Data in to Char Fields and then download...

Thanks and Regards

Pushkar Joshi

[former_member585060]

Select all the cells of MATNR field in Excel sheet Right click and click on Format, select as number or General type.

Edited by: Bala Krishna on Aug 18, 2008 5:27 PM

Edited by: Bala Krishna on Aug 18, 2008 5:29 PM

[Former Member]

We have done all the possible solutions which were replied to the question but the problem is not yet solved.

While downloading, we have converted all fields to Char type.

After downloading if we change the format of the cells, it is giving junk data instead of actual material number.