Powerpivot ignore's decimal separators

[Bibianne]

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

 

[gazpage]

That is strange. I could understand something going on with the percentages, where 85% and 0.85 are basically the same thing, but the 0.2 vs 2 I don't get.

Can you share a simple example of the problem, maybe using expirebox.