Problem with data type from an excel file

[mork]

Hello,

I have a simple excel file with a single table that I'm trying to implement to my report. My problem is that one of the colums has number data that power bi recognises as dates.

The columns has data like 2/4, 3/4 etc. Basically it says how many tests have been done (2 out of 4, 3 out of 4 etc.).

When I import the excel to Power BI that columns shows dates, when I change the type in Power BI to number I get weird numbers like "42462" or something. How can I fix that?

[Sean]

@mork

Look at my response here...

http://community.powerbi.com/t5/Desktop/Sort-a-columns-by-the-rows/m-p/29830#U29830

Basically don't load the Excel data immediately - hit EDIT first - then in the Query Editor change the Data Type to decimal

then go ahead and load to the Data Model

let me know if this works.

[mork]

Decimal number gives me an error. Only text type show the correct data. Should I keep it as text or try something else?

[Sean · Accepted solution]

@mork Go back in Excel and format the column as Fraction - it should then automatically recognize it as numbers

[mork]

Thanks a lot!!