 |
 | 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 / Setup / May 2006How do I keep Excel from dropping my numbers to 0 after 15 digits
I am doing large number data entry, and excel is automatically converting my numbers to zeros after the first 15 digits... 123456789123456789 comes out looking like 123456789123456000 It also appears to be calculating against the incorrect values. Can anyone help??? Excel keeps track of 15 significant digits. If you're using these as text (phone numbers/id numbers), then preformat those cells as text or start your data entry with an apostrophe: '12345678901234567890 Are you trying to do calculations against these values? > I am doing large number data entry, and excel is automatically converting my > numbers to zeros after the first 15 digits... > 123456789123456789 comes out looking like 123456789123456000 > It also appears to be calculating against the incorrect values. > Can anyone help???  SignatureDave Peterson |
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.