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

"Jill" wrote in message
...
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