Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 05-16-2017, 08:48 AM
Midasbelize Midasbelize is offline long digit error Windows 7 32bit long digit error Office 2010 32bit
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
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

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

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 02:53 AM.

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. is not affiliated with Microsoft