Changing Data Type of number from Text to Whole number

[haykp]

Dear Forum,

Some freshmen question.

I have a number - 14590.0, which I need to change to whole number.

So when I change it to whole number it becomes: 145900.

The last .0 is being added to it.

After changing to decimal number:

I did some search, seems the workaround is at first parse that value as Text and remove .0.

And then change the type.

Is this the only way?

Isnt there nice way?

Thanks

Hayk

[haykp · Accepted solution]

I think I found the reason, it was becasue of regional settings. It was setup German on my side, after I changed it to English it worked,

[jdbuchanan71]

@haykp 

In your first screen shot, the ABC123 header means that column is set to Data Type 'Any'.

I created sample data and I am able to change from 'Any' to 'Whole Number' without a problem.  Does it not behave the same for you?

[haykp]

Yes, you are right. The type is Any type. 

But when I changed to "Whole Number" the .0 is added to the numbers

May be it is some tool settings, I need to change?