formula question

T

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

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
[email protected]
 
Top