Microsoft Office Forums - View Single Post - Numbers in Excel will not add using the AutoSum ir Sum functions

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

View Single Post

Old

10-22-2021, 10:26 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit 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