Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers stored as text to numbers
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 -- Gary''s Student - gsnu200903 "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers stored as text to numbers | Excel Discussion (Misc queries) | |||
Convert numbers stored as text to numbers | Excel Discussion (Misc queries) | |||
convert numbers stored as numbers to text | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) |