Numbers in Excel will not add using the AutoSum ir Sum functions

		Microsoft Office Forums > Microsoft Excel > Excel
Numbers in Excel will not add using the AutoSum ir Sum functions

FAQ

Thread Tools

Display Modes

10-22-2021, 10:26 AM

Logit

Windows 10 Numbers in Excel will not add using the AutoSum ir Sum functions

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:36 PM.