View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_177_] mudraker[_177_] is offline
external usenet poster
 
Posts: 1
Default Changing Text into Numbers, using VBA

Sub ffff()
Dim C As Range
For Each C In Range("c1:c10")
C.NumberFormat = "0"
C.Value = C.Value
Next
End Su

--
Message posted from http://www.ExcelForum.com