Not able to convert from dd.mm.yyyy to dd-mm-yyyy while downloading file as excel

[former_member686690]

Not able to convert from dd.mm.yyyy to dd-mm-yyyy while downloading file as excel.

I am able to download format with *, _, . (star, dot,underscore) but not able to download file with Hyphen (-) format.

[FredericGirod]

did you try ABAP2xlsx ?

[Sandra_Rossi]

You didn't post any screenshot or file in SAP Community, please check again.

[Sandra_Rossi]

We don't know what is your context, so it's impossible to answer.

[raymond_giuseppi]

• How did you build some excel data (or did you pass not actual Excel data)
• How did you download the file
• Did you look at your downloaded data with notepad or notepad++
• Which version of Excel did you use, what are your Excel settings
• etc.

[Mathys]

In general what comes out in Excel is using the format that Excel "thinks" you are using.

If you want data to appear in a certain format you have to provide that format, so in this case you need to format it using abap as dd-mm-yyyy and then store it in a char10 field rather than a dats one.

The other option is to reformat the column once the data is in Excel.

[former_member686690]

Internal table data is getting valid format

but when it comes to excel i am getting still the wrong format

[Mathys]

Good morning,

It is difficult to answer your question as you have a lot of tags assigned, but not any indication of how or where the download is processed from.

[former_member686690]

i can see the valid data in internal table but not able to get the same when trying to download from sap to excel (using GUI download)