Convert range of text to values
 

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

Convert range of text to values
 

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

Convert range of text to values
 

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

Convert range of text to values
 

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