Number formatting not happening

[luckyros]

Hi,

I am trying to copy 1101902822941217 from webpage to excel cell. But the last number always comes as "0" instead of "7" after formatting it to number.

I tried all the formatting options but same thing happens. Also if i type any number after 7 it always display "0" instead of that number. Can you please advice on which formatting i should use ?

[ConneXionLost]

Excel only uses 15 significant figures for numerical values.

Try formatting the cell as text before entering the number, or just place a single apostrophe ' in front of the number as you enter it.

Cheers,