Thread: How do I convert a table into a list in excel?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default How do I convert a table into a list in excel?
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
Reply With QuoteReply With Quote