Hi,
When creating a power pivot from two different excel files, all comma's and dots are ignored after importing or refreshing. For example:
In my excel file "Productivity", I have a column with percentages (also percentage format), and a column with time units (for example 0.3 of an hour). After I create a powerpivot, the decimal separators are ignored completely. For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Excel file[/TD]
[TD][/TD]
[TD]Power pivot[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Productivity[/TD]
[TD]Hours[/TD]
[TD]Productivity[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]employee 1[/TD]
[TD]85%[/TD]
[TD]0.3[/TD]
[TD]85[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]employee 2[/TD]
[TD]70%[/TD]
[TD]0.2[/TD]
[TD]70[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
What I want is:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Powerpivot[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Productivity[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]employee 1[/TD]
[TD]0.85[/TD]
[TD]0.3[/TD]
[/TR]
[TR]
[TD]employee 2[/TD]
[TD]0.70[/TD]
[TD]0.2[/TD]
[/TR]
</tbody>[/TABLE]
My settings:
Decimal separator: .
Thousands separator: ,
Language settings excel:
Editing Language: English (US)
Display and Help Language: English(US)
Powerpivot settings:
Language Options: Match Excel Language
Current Language: Inglés (Estados Unidos)
Model Language: Inglés (Estados Unidos)
Computer Settings:
Using Parralles to run Microsoft Excel 2013 on my macbook
The window's is set in Spanish (as I'm working in Colombia atm), however I changed the current location in "Regional Settings: to US (Estados Unidos). Same as the Format, is also set to US.
Could someone take a look and help me?
Thanks!,
Bibianne
When creating a power pivot from two different excel files, all comma's and dots are ignored after importing or refreshing. For example:
In my excel file "Productivity", I have a column with percentages (also percentage format), and a column with time units (for example 0.3 of an hour). After I create a powerpivot, the decimal separators are ignored completely. For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Excel file[/TD]
[TD][/TD]
[TD]Power pivot[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Productivity[/TD]
[TD]Hours[/TD]
[TD]Productivity[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]employee 1[/TD]
[TD]85%[/TD]
[TD]0.3[/TD]
[TD]85[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]employee 2[/TD]
[TD]70%[/TD]
[TD]0.2[/TD]
[TD]70[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
What I want is:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Powerpivot[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Productivity[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]employee 1[/TD]
[TD]0.85[/TD]
[TD]0.3[/TD]
[/TR]
[TR]
[TD]employee 2[/TD]
[TD]0.70[/TD]
[TD]0.2[/TD]
[/TR]
</tbody>[/TABLE]
My settings:
Decimal separator: .
Thousands separator: ,
Language settings excel:
Editing Language: English (US)
Display and Help Language: English(US)
Powerpivot settings:
Language Options: Match Excel Language
Current Language: Inglés (Estados Unidos)
Model Language: Inglés (Estados Unidos)
Computer Settings:
Using Parralles to run Microsoft Excel 2013 on my macbook
The window's is set in Spanish (as I'm working in Colombia atm), however I changed the current location in "Regional Settings: to US (Estados Unidos). Same as the Format, is also set to US.
Could someone take a look and help me?
Thanks!,
Bibianne