internal Table to CSV

[Former Member]

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

[Former Member]

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