Convert from text to numbers

[aviadht]

Hi,

How can i write in vba code that take a range of text and convert it to number ?

Thanks,
Aviad

 

[Trevor G]

Try something like this:

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Macro1()<br><br>    Range("E2:E17").NumberFormat = "0"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[aviadht]

still text )-:

 

[Sektor]

If Trevor's code doesn't work, try this:
1) Enter into some cell 1 and copy this cell with Ctrl+C.
2) Select your range.
3) Right-click on this range and select "Paste Special..."
4) In "Paste" section choose "Values" and in "Operation" section choose "Multuply."

 

[Trevor G]

still text )-:

Please show some sample data so this can be checked for you.

 

[aviadht]

i did paste values and add so now its ok (-:
Thanks

 

[j844929]

Just an update for the vba to do this, in case anyone is looking for it:

Select the range of cells to convert to numbers and run the following:

Code:

Sub Convert_To_Number()
For Each xCell In Selection
xCell.Value = CDec(xCell.Value)
Next xCell

End sub

\Code

Hope this helps if you're looking...

 

[mirabeau]

j844929,

You may find

Sub x()
Selection.Value = Selection.Value
End Sub

is briefer, faster, and less prone to error.

Assuming, as all of this seems to, is that the "text" is numbers stored as text.