 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Entering 16 digit numbers in cell
When I type in the 16 digits, Excel changes the last digit to 0 so I don't have a correct number listed. How can I get it to accept all 16 digits correctly? Thanks Excel, like nearly all software, supports only 15 digits of precision. Anything beyond that is no man's land. If you need to store a longer number but not perform calculations with it (e.g., a credit card number or phone number), precede the number with an apostrophe. The apostrophe will not be visible in the cell but will be visible in the formula bar.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) > When I type in the 16 digits, Excel changes the last digit to 0 so I don't > have a correct number listed. > How can I get it to accept all 16 digits correctly? > Thanks Hi either pre-format the cells as Text, or enter a single quote before the number, which will force it to be text. '0123456789012345 SignatureRegards Roger Govier > When I type in the 16 digits, Excel changes the last digit to 0 so I > don't > have a correct number listed. > How can I get it to accept all 16 digits correctly? > Thanks > Hi > [quoted text clipped - 7 lines] > > How can I get it to accept all 16 digits correctly? > > Thanks |
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.