 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / February 200616 + digit numbers don't display correctly
i am trying to enter account numbers for credit cards-traditionally 16 digit numbers. Excel drops the 16th digit and changes it to a 0. I have tried cutom formatting the cell to 17 digit numbers (and every other formatting trick I can think of) and it will then show 00 at the end. I need help please. > i am trying to enter account numbers for credit cards-traditionally 16 > digit numbers. Excel drops the 16th digit and changes it to a 0. I have > tried cutom formatting the cell to 17 digit numbers (and every other > formatting trick I can think of) and it will then show 00 at the end. I > need help please. I solved my own problem by entering dashes between each set of 4 digits. Don't know why this works but it does what I need it to. I managed to solve the problem by entering dashes between each set of 4 digits. Don't know why this works but it has solved my dilema for now. Would still like to know how to enter 16 digits with some numeral other than 0 at the end. On 2/18/06 12:43 PM, in article 1140295400.832790.205430@g44g2000cwa.googlegroups.com, "Greg" <greg-nicholson@comcast.net> wrote: > I managed to solve the problem by entering dashes between each set of 4 > digits. Don't know why this works but it has solved my dilema for now. > Would still like to know how to enter 16 digits with some numeral other > than 0 at the end. Due to the dashes - i.e. characters which are not numerals - Excel knew it wasn't really a number and formatted it as text by itself. To do the same without the dashes, do what JE says - either prefix an apostrophe (which does not display in the cell unless you double-click it) or format the cell or column as Text in Format/Cells...  SignaturePaul Berkowitz MVP MacOffice Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html> AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/> Please "Reply To Newsgroup" to reply to this message. Emails will be ignored. PLEASE always state which version of Microsoft Office you are using - **2004**, X or 2001. It's often impossible to answer your questions otherwise. > i am trying to enter account numbers for credit cards-traditionally 16 > digit numbers. Excel drops the 16th digit and changes it to a 0. I have > tried cutom formatting the cell to 17 digit numbers (and every other > formatting trick I can think of) and it will then show 00 at the end. I > need help please. XL has a limit of 15 decimal digits of precision, so anything after the 15th digit will be truncated (or, if generated by a calculation, rounded). You can see the same thing by entering 1.234567890123456 What will be stored is 1.23456789012345 Since it's a credit card number, and you won't be doing any math with it, you can enter it as Text. Either preformat the cell as Text, or prefix the entry with an apostrophe: '1234567890123456 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.