Log in

View Full Version : Solved: Text to Number



alopecito
12-22-2008, 09:34 AM
Hi,
I need your help again, I came across with a problem on one of the reports I'm doing, I need to sumarize several cells with data, but when I pull the report Excel don't reconize those numbers as numbers but as text, I try every single text to number I found but nothing seems to be working..Please help..!
Thx

alopecito
12-22-2008, 09:36 AM
In the sample I submmitted the columns I need to add are G:J
Thx

MaximS
12-22-2008, 10:17 AM
that should help:


Sub converter()
Dim Rng, c As Range
Dim LRow As Long
Dim temp As Double
LRow = Range("A" & Rows.Count).End(xlUp).Row
Set Rng = Range("G2:J" & LRow)
For Each c In Rng
temp = Trim(c.Value)
c = temp
Next
End Sub


then apply your excel formulas and formatting

alopecito
12-22-2008, 10:29 AM
Thanks it works perfect!:bow: