>>Hello,
>>
>>How do you convert a string in an Excel cel to either a number to do artihmetic or a formula to evaluate.
>>
>>Examples:
>>String in cell: " 5.00" Want to convert to number 5.00
>>String in cell: "=SUBTOTAL(9,J4:J10)" Want to convert to formula =SUBTOTAL(9,J4:J10)
>>
>>I've tried Excel copy / paste special with no success.
>>
>>TIA,
>>
>>Alex
>
>Did you try setting NumberFormat for your first problem? And setting formula for the second?
>
>Re: Excel Automation Formatting and F9 Thread #1372023 Message #1372036

I found this: http://support.microsoft.com/kb/291047