numbers not displaying correctly

[gold9er]

ok i tried to format the cell by right clicking/format cells/number/number/change decimal places to 0. (not sure i did this right). now...when i insert this number in the cell and press enter-> 4888900013121876..it changes to 4888900013121870.
how can i insert the number 4888900013121876 and it will be the same after i press enter. this caint be this hard.

[romperstomper]

Format the cell as Text or prefix the number with an apostrophe before you enter it.

[Spencer101]

Excel can only cope with numbers up to 15 digits. After that it drops the last one and replaces with a zero.

Depending on what you need to do with that number, one way around it is to format the cell(s) as text.

[gold9er]

formatting the cell as text worked. thanks