PowerPivot ignores decimal

[asusetyo]

Hi All,

Okay, I am new with this power pivot.
I am trying to import data from Excel field to Power Pivot,

My excel data value shows 0.333333333333333
BUT when I import it to PowerPivot it became 333,333,333,333,333.00

Why? did I miss something?

Thanks,
Adit

 

[scottsen]

You are blowing my mind. Can you share out the file? This I gotta see...

 

[greg kramer]

Yes, was hesitant to reply because I have not seen this behavior before.

 

[asusetyo]

Well guys, nice thing to see, I did some trial on language selection, change dot to coma, coma to dot, and I also change my language from Indonesia to English (United States) and it solve the problem. I don't know why, maybe because the language version in my excel and powerpivot isn't match properly.

And, I don't know how to insert a picture..