>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