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 :-(