Excel cell format

[Former Member]

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

[Former Member]

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.

[geetha_k]

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