Problem in downloading date into Excel sheet

[Former Member]

Hi Experts,

We are trying to download a date to Excel sheet with the format 10/2007, but it it getting displayed as Oct/2007. Please advise to retain the same format.

Thanks in advace,

Vivenchandar

[Former Member]

check ur Excel settings, MACROs are present in ur excel.

Regards

Peram

[Former Member]

Hi,

After Uploading select the full DATE Column change - > Right click _ Select the Formatting - > Select the Date Formatting .

Then change according to your wish.

Regards,

Nandha

Rewards if it helps

[former_member189059]

try adding the character<b> ' </b>(apostrophe) before your date before sending it to excel

that usually gets rid of excel's formatting and it doesnt show in the cell in the sheet (only shows in the formula bar on the top)

[Former Member]

When I tried to add the apostophe, thru report I could not get the intended output. But this is working fine when I add aposhtohe after downloading. Please advise to control in the program itself.

[former_member189059]

Maybe the datatype of your variable in SAP cannot hold the apostrophe

move to to a string or a char(12) or something like that