formula question

[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

 

[Frank Kabel]

Hi
why not use Edit-Replace?

 

[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

"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]

Duh, your right........I was not thinking yesterday.

Thanks again.