Convert numbers stored as text to numbers
 

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
---------------
Jacob Skaria


"NONTO" wrote:

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.

--
IF GOD IS FOR US WHO CAN BE AGAINST US?