Number conversion.

[Former Member]

Hi,

Iam downloading some data from sap to excel.

In that one field length is char18 .it saves in excel like 6.36081E+11(original value is 636080900257).

now i want to upload same excel into sap.

iam getting same filedvalue in internal table is 6.36081E+11. how can i get the original value (636080900257).

Regards,

Suresh.

[Former Member]

Hi,

Iam downloading some data from sap to excel.

In that one field length is char18 .it saves in excel like 6.36081E+11(original value is 636080900257).

now i want to upload same excel into sap.

iam getting same filedvalue in internal table is 6.36081E+11. how can i get the original value (636080900257).

Regards,

Suresh.

[Former Member]

while downloading check if your excel Cells format is FRACTION . if not change it to FRACTION ..

[Former Member]

That's is a functionality of excel nothing can be done , if you want to have the original value download the file in CSV format and use the same for further processing.

Format setting in excel will not help in getting your original values it will add zeros as per E ^ power

[Former Member]

try to assign this number into packed decimal

Regards

sasi

[Former Member]

or try with FM MURC_ROUND_FLOAT_TO_PACKED

Regards

Sasi

[Former Member]

before displaying you can change the number to type p (packed), declare a packed variable and assign it to the same.

With luck,

Pritam.

[Former Member]

Declare one variable with type packed. Pass those converted values to this packed variable.

Regards,

Joan

[abdulgaffarmohd]

Hi suresh ,

you can do one thing in XL ,

just right click on this column and select formatcells and select number.

and double click on that column the XL-column will be converted into number .

Regards,

Mohameed.