Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 03-09-2016, 01:36 AM
macropod's Avatar
macropod macropod is offline Excel error in inputting long numbers Windows 7 64bit Excel error in inputting long numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,370
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It is not an error, it's a documented limitation that has been around for many years. The 15-digit resolution limit is part of the Excel specifications, which XOR suggested you read. See: https://support.office.com/en-us/art...7-269d656771c3 - returned by inputting 'Excel specifications, Calculation specifications and limits' into a web search. It also explains why the format suggested by gebobs won't work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel error in inputting long numbers Inputting a number into word in a specific format Jo 4x4 Word 7 07-19-2014 12:45 AM
Excel error in inputting long numbers Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
Renaming Word Formfields: string too long error silverspr Word VBA 7 01-22-2013 06:20 PM
Inputting Sound files - 2 options, neither working. msteinruck PowerPoint 0 09-16-2010 09:44 AM
Inputting variable data axy Word 0 09-08-2009 04:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:38 AM.


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