First, my apologies for not clarifying my requirements.
Basically, on my file, "Page 1" thru "Page 39" all the cells from "D6:F385" has the green triangle (which I failed to mentioned) in the upper left corner of the cell. Probably, calling this "converting text to numbers" is not the right thing to do.
By applying the following number formatting, the green triangle in the upper left corner of the cell goes away, which is my intended result.
Code:
Sub Converting_Text_To_Numbers_1()
Range("D6:F385").Select 'specify the range which suits your purpose-same range for all other sheets
With Selection
Selection.NumberFormat = "###000"
.Value = .Value
End With
End Sub
The current code or macro is only working for the sheet name "MyData".
If you can provide me a macro that will change the text to number and the number format for "Page 1" thru "Page "39", then it will meet my requirement.
Hoping this time I got the message across, and again sorry for the confusion!
Cheers!