Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert extracted number - Paste Special / Add
Hi All, I am trying to automate part of a manual process which I regularly hav to do. I extract some data from a tool but when it is inputted into excel some of the columns are stored as text not a number (i.e. format). This prevents me performing calculations and I am unable to resolve i by simply changing the format. I therefore have to copy the relevant column and then "Paste Special Add" to a blank column so that they are recognised as numbers. Is there a simple way of converting numbers from the "text format" t "numerical" format. i.e. Cell A1 = 1 -------------------- Cell A1 =1 Format = text Format = number Thanks And -- andibeva ----------------------------------------------------------------------- andibevan's Profile: http://www.excelforum.com/member.php...nfo&userid=988 View this thread: http://www.excelforum.com/showthread.php?threadid=32034 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert extracted number - Paste Special / Add
Hi Andy
Select the cells in question and run this little macro: Sub MakeNumbers() Dim Cel As Range For Each Cel In Selection If Cel.HasFormula = False Then If IsNumeric(Cel.Value) Then Cel.Value = Cel.Value * 1 End If End If Next End Sub HTH. Best wishes Harald "andibevan" skrev i melding ... Hi All, I am trying to automate part of a manual process which I regularly have to do. I extract some data from a tool but when it is inputted into excel, some of the columns are stored as text not a number (i.e. format). This prevents me performing calculations and I am unable to resolve it by simply changing the format. I therefore have to copy the relevant column and then "Paste Special / Add" to a blank column so that they are recognised as numbers. Is there a simple way of converting numbers from the "text format" to "numerical" format. i.e. Cell A1 = 1 -------------------- Cell A1 =1 Format = text Format = number Thanks Andy -- andibevan ------------------------------------------------------------------------ andibevan's Profile: http://www.excelforum.com/member.php...fo&userid=9882 View this thread: http://www.excelforum.com/showthread...hreadid=320345 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
How do I capture user paste action and convert to Paste Special | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |