Change text to number format_ little twist :)

[pedie]

'm looking to change all my data around 1200 rows to number format...

30% of the data contains formula result though it appears to be blank it is not...it is showing as text format...I want all this blanks and non blanks to be converted to numbers.

Thanks for helping in advance.

Workboook "book1.xlsm"
Sheets("sheet1")
Range(A:T) rows till 1200.

PS: And pls let me know the fastest way to do it....Thanks

 

[meldoc]

Hi Pedie

Maybe this.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>  <SPAN style="color:#00007F">With</SPAN> Range("A1:T1200")<br>    .NumberFormat = "general"<br>    .Value = .Value<br>    .SpecialCells(xlCellTypeBlanks) = 0<br>  <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>