Function Module to convert Exponential form into integer.

[Former Member]

Hi all,

when uploading the excel file into an Internal table, I need the values entered in Exponential form to be convered into Integer.

For example, 7.62E+14 must be convered to 762000000000000.

Is there any Function Module available for conversion.

Thanks in advance.

[Former Member]

download using OLE concept.

Check this

Reg,

Sachin

[Former Member]

do using OLE concept

Check thi link

Reg,

Sachin

[Former Member]

During upload, automatic conversion will take place, and there is not FM for this conversion.

manual conversion will have to be done using type-casting.

Regards,

Mansi.

[Former Member]

Hi sumitha,

Use the FM:

KKEK_CONVERT_FLOAT_TO_CURR

Regards,

Nitin.

[I355602]

Hi,

Refer FM C14W_NUMBER_CHAR_CONVERSION

Hope this helps you.

Regards,

Tarun

[Former Member]

Hi,

Use FM *QSS0_FLTP_TO_CHAR_CONVERSION* for this purpose.

Pass the Floating point value to i_fltp_value and get the converted number in e_char_field.

-Rakesh

[Former Member]

I would prefer, instead of using any Fm, Once you get the value to your field, move it to a variable

of type p.

Regards,

Nitin.

[Former Member]

the FM QSS0_FLTP_TO_CHAR_CONVERSION, is working fine. thanks a lot for everyone's effort.