internal Table to CSV

Former Member — Thu, 20 Dec 2012 08:15:20 GMT

Hello,

i created a csv file with the function -> *CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

In my internal table there bank account numbers, these numbers are > 10 (char),

if I open this csv with excel I got those numbers displayed as 4,71111E+11 !

But I got a different .CSV file with the same numbers in it and if I open that file with excel the number 4,71111E+11 is displayed as 471111111111 and need it that way!

Can somebody explain me what I did wrong or what can i do?

Kindly regards,

Nico

Re: internal Table to CSV

Former Member — Thu, 20 Dec 2012 11:45:51 GMT

hi mark

try this

open your excel file and right click on the top of the column (of the desired field value) and choose format cells

in that you can change it from general to number.

regards

vaibhav

topic internal Table to CSV in Application Development and Automation Discussions

internal Table to CSV

Re: internal Table to CSV