Skip to Content
avatar image
Former Member

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

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???

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 18, 2010 at 10:59 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2010 at 11:09 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jun 18, 2010 at 11:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 18, 2010 at 11:37 AM

    HI,

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

    With Regards,

    Sumodh.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2010 at 03:22 PM

    Moderator message - Please search before asking - post locked Rob

    Add comment
    10|10000 characters needed characters exceeded