View Single Post
 
Old 03-09-2016, 01:36 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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