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

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"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

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

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