Convert to Number

[pells]

I have an error on my worksheet that advises me that I have a number stored as text. I can convert the cell to number format manually, but was wondering whether this can be done via VBA code as I need to do this on many workbooks?

Many thanks.

 

[pells]

Maybe

Sub ToNos()
With Workbooks("Workbook1.xls").Sheets(1).Range("C6")
    .NumberFormat = "General"
    .Value = .Value
End With
End Sub

BRILLIANT! Thank you very much or all your help, this works perfectly now