value error in bex

[Former Member]

I am reporting on a multiprovider and the cell value for one infoobject on the report appears with a green triangle on the upper left corner. when i click on that cell i get a messgae stating "The number in this cell is formatted as text or preceded by an apostrophe". what should be done to get rid of this.

[Former Member]

Hi Centrino,

Use Excel menu path: Tools-Options, Error checking tab, uncheck 'Number stored as text' flag.

Best regards,

Eugene

[Former Member]

thanks eugene. i'll try that tomorrow.

[former_member188975]

Hi Centrino,

What you mention is actually an excel property, nothing to do with BEx. Try to change the property of the cell(s) in which you are getting this value.

Hope this helps...

[Former Member]

thanks bhanu. what do i need to format. this particular infoobj is of type char and length 12. in the cell which has the error i have a value 10110111 with a green shade. if possible could u explain more.

thanks

[former_member188975]

Hi Centrino,

Excel is trying to tell you that the number that you have in the cell is being considered as a text. What you can try out is, highlight the cell and from the Excel menu > Format > Cells. Try making it a number.

Hope this helps...

[Former Member]

sorry bhanu, i made that cell as a number before and still got that green shade. after that only i replied to ur post. any other suggestions u would recommend.