Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2017, 08:48 AM
Midasbelize Midasbelize is offline long digit error Windows 7 32bit long digit error Office 2010 32bit
Novice
long digit error
 
Join Date: May 2017
Posts: 1
Midasbelize is on a distinguished road
Default long digit error

when i type this number 5665866763562961


i get this error 5.66587E+15 in the cell and when i click it then changes the digit to 5665866763562960

look forward to your help
Reply With Quote
  #2  
Old 05-16-2017, 10:14 AM
NBVC's Avatar
NBVC NBVC is offline long digit error Windows 7 64bit long digit error Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

It's not an error it is scientific notation for representing large number. ... Excel has a precision limit of 15 digits so anything after the 15th digit becomes a zero.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting a digit from a code Warren99 Excel 2 05-29-2016 04:08 AM
long digit error Excel error in inputting long numbers johnharbo Excel 12 03-09-2016 10:04 PM
Regex/wildcard search for dates with 2-digit and 4-digit years Marrick13 Word VBA 2 01-29-2016 07:04 AM
long digit error A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 laucn Excel Programming 14 05-17-2015 12:12 PM
Renaming Word Formfields: string too long error silverspr Word VBA 7 01-22-2013 06:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft