How do I convert a table into a list in excel?
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
|