| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert text to values
phew, i was afraid for a moment that this solution was no longer possible with xl2007 +
thanks Ron, and have a good night -- isabelle Le 2012-04-27 20:15, Ron Rosenfeld a écrit : On Fri, 27 Apr 2012 19:47:46 -0400, wrote: hi Ron, why make a loop ? Sub MakeNumeric() Selection = Selection.Value End Sub -- isabelle I should have added that what your version does what I posted without the loop; but does not do what I meant to post :-( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I take a string of text and convert it ASCII Values? | Excel Discussion (Misc queries) | |||
| convert to values numbers as text | Excel Programming | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| Convert range of text to values | Excel Programming | |||
Threaded Mode
