Only the second column in the range is a numeric cell the rest are text.
Does that effect the output? This macro gave me a runtime error when put
into the sheet.

Run-Time error '1004'
Application-defined or object-defined error

How can I correct this error?

Thanks for your help.

"Jarek Kujawa" wrote:

sorry

should be:

select yr resultant column

Sub formattt()
For i = 2 To 200000 Step 4
Cells(i, 6).NumberFormat = "0.00"
Next i
End Sub

if the result is still in column 6