remove commas from number

[wirata]

Hi Guys, i have some problem here :

For example, i have some data :

123,123567
12,778
9822,1
8267,222223

then, i want to permanently remove the comma, so the result :
123
12
9822
8267

You guys have idea about it? because if i use format cells -> use 1k separator, the data actually still contain the comma (even if the looks is 123, but in the formula bar, it stated 123,123567)

Sorry for my grammar, haha :D
Thanks guys

[Pepe Le Mokko]

For a one shot eventually use Data - Text to columns - Delimited - use comma as delimiter - Select " do not import" the second column in the wizard's last window

[wirata]

woahhhhh :D , thankss Pepe Le Mokko, it works