File data problem

[Former Member]

Hi Expetrs,

Using the 'GUI_download' Fuction module I am downlaoding the data in the EXcel file with the tab delimiter.

In the Internal table One filed data like '1020200040102730' after downloading the data into the Excel its showing like '1.0202E+15'.

All ways (after downloading the data) I want the data like '1020200040102730'.

Please suggest me.

Thnx,

Sam

[Former Member]

Hi,

The Excel file to which you are downloading the data:

Select the column to which the specific numeric data will get stored.

Right click on selected whole column > Format Cells > Select 'Text'.

Then Download.

If still the problem persists try passing the numeric data as type char10 char15 whatever.

Regards.

[Former Member]

Define this field as character Field, so at the time of exel download it will give you proper Output

Regards,

Alpesh

[Former Member]

hello,

well the only solution i have found to this problem till now is that you will need to concatenate a character in from of the number: '00000003454484 or format the fields in your excel sheet.

kevin

[former_member242255]

it is displaying as 1.0202E+15 due to format of the cells inthe excel sheet.

the formt of the cells should be Number ,if it is General it displays like the above.

[Former Member]

Hi Sam,

Please Select the Single Field or the Column you want to convert.

Right Click on them ->Go to Format Cells ->Select the Category Number With Decimals Place '0'.


Then Click on Ok

Thanks

kalyan

[Former Member]

actually the value should be in character format.

this happens with the interger value

if you could place ' ' ' before the value i.e '12345678 in excel

then u'll have no problem

[Former Member]

HI,

In the Excel Sheet, Select the Coloum, Right Click it

Then Secect Number---> The below the Negative Number Part Select 123,10 --> than OK

Then do the downloading ,

This will solve ur problem.

Thanks and Regards'

Suraj S Nair