Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 11-03-2017, 11:55 PM
ArviLaanemets ArviLaanemets is offline Entering a number of 19 digits Windows 8 Entering a number of 19 digits Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Btw., there is a workaround for 15-number limit. A cumbersome one, but when someone needs to make exact mathematical calculations with such numbers, then:
1. Divide the number to 2 parts and enter them in separate cells (columns). (you can also enter the long number as text, and use formulas to divide it.)
P.e. to make calculations with integers like 123456789012345678 enter it as 123456789 and 12345678, or to make calculations with decimals like 0.123456789012345678 enter it as 0,123456789 and 12345678 (or 0.012345678);
2. Design formulas (or user-defined functions) for mathematical operations with such number pairs. NB! You need 2 formulas for one operation. And when you write a function, then it must have a parameter, determining which part of result is returned. You can then use formula to get result returned as long number in text format too.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Having number's digits together mohsen.amiri Word 0 06-23-2017 01:20 AM
Entering a number of 19 digits Digits are not found in my document! reza8615953 Word 3 04-18-2017 10:48 AM
Entering a number of 19 digits Entering a number in a cell causes it to fill with the color of a nearby cell Bill Martz Excel 1 04-23-2015 07:57 PM
Separate the digits into 3 combinations Jasa P Word VBA 1 08-19-2012 11:04 PM
Entering a number of 19 digits Problems merging in last 4 digits of an account higher than 16 digits Glynda Mail Merge 1 04-08-2011 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 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