07-20-2007 12:23 PM
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
07-20-2007 12:32 PM
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)
07-20-2007 12:25 PM
check ur Excel settings, MACROs are present in ur excel.
Regards
Peram
07-20-2007 12:31 PM
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
07-20-2007 12:32 PM
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)
07-20-2007 12:48 PM
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.
07-20-2007 1:15 PM
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