PowerPivot ignores decimal

asusetyo

Board Regular
Joined
Feb 18, 2014
Messages
50
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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

scottsen

Well-known Member
Joined
Mar 16, 2014
Messages
1,263
You are blowing my mind. Can you share out the file? This I gotta see...
 

asusetyo

Board Regular
Joined
Feb 18, 2014
Messages
50
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.. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,707
Messages
5,524,424
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top