Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #15  
Old 06-13-2020, 07:15 PM
Purfleet Purfleet is offline Trying to count the lines in a grouping Windows 10 Trying to count the lines in a grouping Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

It is becuase of the size of the number - excel can only deal with (i think) 15 significant figures and anything else is rounded.


For exmaple if you put 377540323190869743517.9993055556+0 in an other cell it will show as 3.7754e+20, then increase decimals to the max and you will see the cell is actually showing 3.775403231908690000000e+20..


Drop off the zeros and filter for 377540323190869 and you will get 16, which is how many the count is counting.


Now to get around that.......
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping Lines by Project number on a separate page taholmes160 Excel 2 04-17-2019 03:57 AM
Trying to count the lines in a grouping How to count words in a text, arrange them in separate lines and put the grammar class ? Marcway Word 6 12-14-2018 04:25 PM
Trying to add space between lines of bulleted text and a new header but both lines are moving??? Martin_d35 Word 2 02-10-2017 07:13 AM
Trying to count the lines in a grouping Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
Trying to count the lines in a grouping Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM

Other Forums: Access Forums

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