leading zero.s not coming at the time of gui_download to excel file

[Former Member]

Hi,

I am downloading int. table data to excel file by help of gui_download.

here one field marm-meinh , value in int. table had 097 but at the time of download to excel it is giving only '97 ' , this probleam i am facing ..Can u help me???

[Former Member]

HI,

Its the excel property - You can't do anything with it.

You can check it:

Please try to put any number with leading zeroes in a cell of an excel sheet and try to go to other cell.

You will see that the leading zeroes will be gone and only numbers will be there,

Thanks!

[Former Member]

Hi suhas,

R u downloading from ALV.. If yes there is field in fieldcatalog - No_convext: set this field to X..

U will get zeros when u download..

Best Regards,

navin fernandes.

[Former Member]

No I am using gui_download FM ...

Please help...if any other sol. there

[Former Member]

As per me , this is a standard excel behaviour to remove the leading zeros for numeric field ..

what you can do is to add single quote character (') before the numeric value and try to download it into excel.

Thanks!

[Former Member]

hi,

since u are using gui_download..

Try setting the following importing parameters as X..

WK1_N_FORMAT = 'x' or

WK1_T_FORMAT = 'x'.

Hope this helps,

best Regards,

navin fernandes.

[ravi_lanjewar]

Hi,

When you download the into excel numric fields leading zero will remove. You defined that fields type as character (ie. Char type or numc type)

Then try to download it will work.

Rgds

Ravi Lanjewar

[pramodu]

Hi,

Whenever you download any value numeric value or value with leading zeros in excel, it downloads without zero.

In order to convince your cutomer, you show to your customer that download the file from table ( Ex. MARA , material with leading zeros) and it will be download material without zeros. This proves it not the programming issue.

Other way you can download it in .text file where it downloaded with zeros.

Thanks,

Pramod

[former_member536879]

HI,

Just use the File type 'DBF' instead of DAT.

With Regards,

Sumodh.P

[Former Member]

Moderator message - Please search before asking - post locked Rob