Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2021, 10:19 AM
Nednil Nednil is offline Numbers in Excel will not add using the AutoSum ir Sum functions Windows 10 Numbers in Excel will not add using the AutoSum ir Sum functions Office 2016
Novice
Numbers in Excel will not add using the AutoSum ir Sum functions
 
Join Date: Oct 2017
Posts: 3
Nednil is on a distinguished road
Default Numbers in Excel will not add using the AutoSum ir Sum functions


I have an imported Excel file in which one of the columns has all numbers. When I try to add the column using either the AutoSum or the Sum functions the column will not add. I have tried copying the column to a new workbook with the same results. If I rewrite the numbers in the next column then they will add. Is there some kind of a "lock" on the cells so they cannot be totaled?
Reply With Quote
  #2  
Old 10-22-2021, 10:26 AM
Logit Logit is online now Numbers in Excel will not add using the AutoSum ir Sum functions Windows 10 Numbers in Excel will not add using the AutoSum ir Sum functions Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

The "numbers" may be text appearing as numbers.

NOT TESTED HERE :

Code:
With Worksheets("Sheet1").Columns(5) 'Col 5 refers to Col E. Edit the number to match your column
    .NumberFormat = "0"
    .Value = .Value
End With
excel - VBA: Convert Text to Number - Stack Overflow
Reply With Quote
  #3  
Old 10-22-2021, 11:36 AM
Nednil Nednil is offline Numbers in Excel will not add using the AutoSum ir Sum functions Windows 10 Numbers in Excel will not add using the AutoSum ir Sum functions Office 2016
Novice
Numbers in Excel will not add using the AutoSum ir Sum functions
 
Join Date: Oct 2017
Posts: 3
Nednil is on a distinguished road
Thumbs up Thanks

A BIG THANK YOU! The problem was that the numbers were stored as text and there is a convert text to numbers under the data tab. I never thought of the numbers would be stored as text.
Reply With Quote
  #4  
Old 10-22-2021, 11:51 AM
Logit Logit is online now Numbers in Excel will not add using the AutoSum ir Sum functions Windows 10 Numbers in Excel will not add using the AutoSum ir Sum functions Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

You are welcome.
Reply With Quote
  #5  
Old 10-22-2021, 11:10 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Numbers in Excel will not add using the AutoSum ir Sum functions Windows 7 64bit Numbers in Excel will not add using the AutoSum ir Sum functions Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by Nednil View Post
A BIG THANK YOU! The problem was that the numbers were stored as text and there is a convert text to numbers under the data tab. I never thought of the numbers would be stored as text.
If you don't apply manual cell alignment , text is aligned left and numbres right, so you can see immediately what is text or not
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Know of any Excel VBA or Excel functions that can help with general lottery forecasting? angExcelentflea Excel Programming 6 08-11-2019 05:15 AM
Numbers in Excel will not add using the AutoSum ir Sum functions give mathematic functions numbers and link in the text Meena2287 Word 3 09-11-2015 05:38 PM
Numbers in Excel will not add using the AutoSum ir Sum functions excel functions Dotty Excel 1 05-11-2015 03:38 PM
Numbers in Excel will not add using the AutoSum ir Sum functions How to Autosum highlighted values in a table like in Excel The_Nster Word Tables 1 01-13-2015 01:27 PM
Numbers in Excel will not add using the AutoSum ir Sum functions Excel 2010 Functions cmf10 Excel 6 07-02-2014 08:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:21 AM.


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