Skip to Content
0
Former Member
Aug 04, 2009 at 10:35 AM

Scientific number in member excel

31 Views

Hi,

How to avoid scientific format in the member excel.The length of ID is 15 so the id values are loaded in dimension id as below.I have tried formating the cell content to text,number. For a while it seems to have changed to proper format but when we close the session and reopen the dimension member excel the member id remain as it is. How to handle this in BPC?

Any inputs?

ID

3E+13

3E+13

3E+13

3E+13

3E+13

3E+13

Regards