View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Change Row of text to values

Please note OP's request.......

I would like to plug solution into existing macro that performs these
mentioned functions.



Gord

On Wed, 14 Nov 2007 21:54:08 -0000, iliace wrote:

Type in 1 in any free cell. Copy this cell. Highlight your data that
you want converted to number. Go to Edit-Paste Special; select
Values and Multiply.