Cells in Excel 2016 not adding

Log Out | Topics | Search Moderators | Register | Edit Profile

Author Message David G. Axt, CCS, CSI ,SCIP Senior Member Username: david_axt Post Number: 1640 Registered: 03-2002 Posted on Friday, March 09, 2018 - 01:48 am:    Today I came across a very disturbing find. Some of the cells in my Excel 2016 spreadsheet do not add when I sum the column. At first I thought maybe the cells were formatted as text instead of numbers. Then I though maybe the 1's were actually L's. I checked to see if the cells were somehow locked or hidden. It is very strange since the cells that don't add appear to be rather random. The only way to correct the problem was to delete all the numbers and re-enter the numbers in each cell. Has anyone come across this issue? David G. Axt, CCS, CSI, SCIP Specifications Consultant Axt Consulting LLC Dewayne Dean Senior Member Username: ddean Post Number: 155 Registered: 02-2016 Posted on Tuesday, March 13, 2018 - 11:11 am:    David, Could you send me the offending spreadsheet? dewayne at nwlarchitects.com John Bunzick, CCS, CCCA, LEED AP Senior Member Username: bunzick Post Number: 1740 Registered: 03-2002 Posted on Thursday, March 15, 2018 - 05:00 pm:    Recalculation only occurs when saving. Did you try that? David G. Axt, CCS, CSI ,SCIP Senior Member Username: david_axt Post Number: 1642 Registered: 03-2002 Posted on Monday, March 19, 2018 - 02:56 pm:    Yes. I sent the file to Dewayne who figured there is some invisible character in front of the number. I have since redone the spreadsheet and will check my addition manually the next time I use the spreadsheet. Thanks Dewayne for your help! David G. Axt, CCS, CSI, SCIP Specifications Consultant Axt Consulting LLC Colin Gilboy Senior Member Username: colin Post Number: 444 Registered: 09-2005 Posted on Monday, March 19, 2018 - 03:11 pm:    Invisible characters are a problem when you cut and paste from Word - I see this all the time working with html and do not understand the double space when one is not obvious until you look at the code. Colin Gilboy Publisher, 4specs.com 435.654.5775 - Utah