If you want it to be treated as a number, I think you’re out of luck. Like most programs, Excel has an upper limit on the accuracy (number of digits) allowed and it isn’t 20. If you just want the entry 12345678901234567890 to display (and be treated like a text string, then you can enter '12345678901234567890. That is, precede it with a single quote. I’m not sure what the upper limit on the length of a string, but it’s at least 100 characters long.
Yeah, you see, this friend of mine who be Prince of Nigeria want to send me his all money fast fast and I don’t want to lose US$$67890. I have to sends him excel sheet with my bank all details.
That did it! I was trying to format it to Text after entering the number. Thanks, kanicbird.
:smack: For some strange reason, I totally missed that. Yeah, that works nicely. Thanks.
A colleague of mine was trying to inventory some SIM cards using Excel, and they have this 20 digit number printed at the back. She didn’t care about the numerical value of the number.