Search results for query: *

THANK YOU!!!!

This might seem trivial...but does anyone know how to get 01 to diplay in the cell when the cell is formated as a Number?

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...

PS Im using Excel XP if that helps...

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...