Problem in data in excel after downloading, record , i shows as 3+01

[Former Member]

hi

i have a problem when downloading data in to excel in pc. the record is displayed as 3+01 instead of 30000013, how to change it from abap side.

thanks,

vijay.

[Former Member]

Hi Vijay,

After downloading into excel please increase the width of the column containing 3+01. Otherwise fallow the fallowing navigation.

Select the cell->Right click->Select Format Cells->Select Number Tab->Number->ok.

[Former Member]

hi,

yes, but the user doesnt want to do it, so is there any way to make up the template of excel.

Thanks,

Vijay

[Former Member]

declare that Field as CHAR(23) type C.

Regards

Peram

[Former Member]

Hi,

The only suggestion for this problem is, increase the width of the field before it is displayed to report.

Reward if found useful.