#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
You are welcome.
|
#5
|
||||
|
||||
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
|
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 |
give mathematic functions numbers and link in the text | Meena2287 | Word | 3 | 09-11-2015 05:38 PM |
excel functions | Dotty | Excel | 1 | 05-11-2015 03:38 PM |
How to Autosum highlighted values in a table like in Excel | The_Nster | Word Tables | 1 | 01-13-2015 01:27 PM |
Excel 2010 Functions | cmf10 | Excel | 6 | 07-02-2014 08:26 AM |