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.
Format the cell as Text or prefix the number with an apostrophe before you enter it.
Anyone who confuses correlation and causation ends up dead.
formatting the cell as text worked. thanks
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.
If I've been of help, please hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks