Convert numbers stored as text to numbers

[NONTO]

I copied data from my online bank statement on to excel. I tried to sum the
numbers and realised that the answer was in correct. I formatted the numbers
to account but still it was incorrect. I realised that if I dragged my cursor
over the columns the sum at the bottom of the sreen added some number and
left out others. I the sought help from the help menu, followed the process
where I typed '1' on a clean cell, copied it, paste special, chose add but it
did not work, I reapeted the process and chose 'multiply' instead but it
still did not work.

I tried the F2 enter procedure but it not work.

Whilst playing around trying to figure out the solution I got to a screen
that showed me that the numbers that were not adding up had " at the begining
and at the end, e.g "2496.48" + 2800 gave me a value error.

How can i change these values into numbers without retyping them, because it
is a lot of data.

 

[Jacob Skaria]

Hit Ctrl+H
Find What: "
Replace with: (leave blank)
Replace All

AND if there are spaces try

Find What: space bar once
Replace with: (leave blank)
Replace All

If this post helps click Yes

 

[Gary''s Student]

Select the cells you want to convert and run this small macro:

Sub MakeNumber()
Dim v As Variant
For Each r In Selection
v = Replace(Replace(r.Value, " ", ""), ",", "")
r.Clear
r.Value = Val(v)
Next
End Sub