Change exisiting text type to decimal

[mincii]

Hi everybody

I am a beginner of powerbi and what to set up a new report in our company. I know that you can change the type of columns but I haven't figure out, how to have an exisiting column as type "text" and change it to type "decimal" with two characters after comma. 

Just to make it a little bit clearer:

1. Is 04909 ---> should be 49,09

2. IS 04906 ---> should be 49,06

3. Is 04711 ---> should be 47,11

4. .....

I tried also to transfer at first step to whole number and then to decimal. --> Did not work

As I want to change this in the query Editor and not in the Excel (This is the source of the column).

Can u maybe help me out? 🙂

Thank guys. 

Br, mincii

[mincii]

Oh jes, just thought wrong. Thanks for the hint, got it.

[HotChilli · Accepted solution]

"I tried also to transfer at first step to whole number and then to decimal. --> Did not work" 

What happened?

This is the right way to do it.

Change type to number or decimal.

It looks like you want to divide by 100 and use a comma as a decimal separator so try that.