Changing from text to number removes decimal (written in comma)

[Niels_T]

Hello,

I have numbers written with a decimal as you see in the following screenshot and I want them to change from text type to numbers type:

The thing is when I change the type from text to decimal numbers then suddenly the comma gets removed (probably because it doesnt use comma as decimal) and I get the following result:

How do I  keep the same value but still being able to choose for the decimal number data type?

[PhilipTreacy · Accepted solution]

Hi @Niels_T 

Right click on the column header and then choose Change Type->Using Locale

Choose Data Type : Decimal and the locale that the numbers are from,for example:

regards

Phil