T Tim Sep 7, 2004 #1 I have a column of 0's and 1's. I need a formula to change the 1's to "yes" and the 0's to "no". Thanks for your help. Tim
I have a column of 0's and 1's. I need a formula to change the 1's to "yes" and the 0's to "no". Thanks for your help. Tim
N Nick Hodge Sep 7, 2004 #3 Tim If you don't want to actually change them, but change the way they are displayed, you could use a custom format Cells...>Number>Custom and type Click to expand... "Yes";;"No"; Else you could use a formula in the next column =IF(A1=1,"Yes","No") and then Edit>Copy, Edit>Paste Special...>Values over the original data to kill the formula -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
Tim If you don't want to actually change them, but change the way they are displayed, you could use a custom format Cells...>Number>Custom and type Click to expand... "Yes";;"No"; Else you could use a formula in the next column =IF(A1=1,"Yes","No") and then Edit>Copy, Edit>Paste Special...>Values over the original data to kill the formula -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
