Thanks for the reply..
It doesnt seem to be putting the " so I tryed the special paste. Is there any specific type of paste I should try? I tryed selecting formulas and it went into the cell correctly ...but agian, when I try to edit it, it leaves the formula in the cell...
Im editing in...
When I past a formula into another cell and try to edit it, the value of the cell displays the formula!?!?!
Ex.
I have the following formula in a cell..
=IF($BA12=1,VALUE(CONCATENATE($AX12,$AW12)),IF($BA12=11,VALUE(CONCATENATE($AX12,$AW12))," "))
When I edit this formula in any...