When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Sub TextToNumber3() Dim rngMyRange As Range Dim row As Integer With Worksheets("Cycle Time") row = 11 Set rngMyRange = .Range(.Range("AD" & row), .Range("AH" & row)) For Each xCell In rngMyRange rngMyRange.NumberFormat = "0" 'Note: use "0.00" for decimal places. xCell.Value = xCell.Value row = row + 3 Next xCell End With End Sub