Number format of cells

Hi administrator,

I greatly appreciate the existence of this site.

Anyway, my excel problem happens this way: I tried to paste three columns of different data unto a new worksheet, the first column of which is a list of contact numbers. Now, I know that when i pasted the data, the contact numbers wouldn't first appear as the contact numbers yet (as in 09321234567, which is how i should want it to appear), instead, all columns have this value: 6.39E+11. But i don't worry because i know its settings are in General format, and all i needed to do is just click on the column, go to FORMAT CELLS and just click on NUMBERS and then reduce the decimal numbers to 0 instead of the default 2 (because of course, contact numbers don't have decimal numbers). There used to be no problem when i did this before, but now, when i change the format into numbers, the last 6 digits of all data are zeroes. I don't know what happened. I hope you can help me. By the way, it appears that this kind of problem is only exclusive to this particular file that I'm pasting, which is weird because it's just basically the same as the other files I worked on.

Thank you very much.

Thank you. I did just that, but it only displays a series of values like this: 6.39334E+11. So I changed them again to the number format, and I get the same zeroes at the last 6 digits, something like this: 639108000000.