Convert range of text to values

[Jill]

Hello,
How do you convert text (with a macro) to values in a
large range of cells?
The spreadsheet always has a range (C25:AJ255) with the
numbers sent as text. I need to change them all back to
values so I can work with them.
I would really appreciate your help.
Thank you very much.
Jill

 

[Rob van Gelder]

You could change the format back to General or Number.

If that's not working, try copying a blank cell, then paste special / values
+ addition

 

[David Adamson]

Jill,

try the following

Just change the Worksheet name

Private Sub CommandButton1_Click()
Worksheets("numbers").Range("c25:aj255").NumberFormat = "###,##0.00"
End Sub

 

[Cecilkumara Fernando]

Jill,
Try,
Sub TexttoNum()
With Range("M1") 'any cell which can be cleared
..Clear
..Copy
Range("C25:AJ255").PasteSpecial _
Paste:=xlPasteAll, Operation:=xlAdd, _
SkipBlanks:=False, Transpose:=False
End With
Application.CutCopyMode = False
End Sub
Cecil