05-19-2008 12:04 PM
Good morning:
I am using the function SAP_CONVERT_TO_XLS_FORMAT for sending an internal table to excel sheet, but i have to send some numbers with 0 in the left and excel is deleting them because of the excel cell format, is there any fast way of doing it without using the oo methods for formating the cells, does anybody use any other way?..
Thanks in advance
regards
Points will be rewarded for vale answered
05-19-2008 12:12 PM
you can put ' (apostofi ) before the required,
value.
excel wil accept this as like 01, 02.
if its works not conver it into text.
it will definatly works.
rewards are expected.
05-19-2008 12:12 PM
you can put ' (apostofi ) before the required,
value.
excel wil accept this as like 01, 02.
if its works not conver it into text.
it will definatly works.
rewards are expected.
05-19-2008 12:14 PM
Hi,
In ur report , after executing the report u will click the PRINT PREVIEW button, and goto system>list>local file--->the u will select the radia button in which way to save the file.u will select select spreed sheet then save in xls format.. okk