Jill,

try the following

Just change the Worksheet name

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




"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