formula question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 07 Sep 2004 20:59 GMT

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

Reply to this Message

Frank Kabel - 07 Sep 2004 21:02 GMT

Hi
why not use Edit-Replace?

Signature

Regards
Frank Kabel
Frankfurt, Germany

> 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

Reply to this Message

Tim - 08 Sep 2004 11:44 GMT

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

Thanks again.

>-----Original Message-----
>Hi
[quoted text clipped - 6 lines]
>> Tim
>.

Reply to this Message

Nick Hodge - 07 Sep 2004 21:09 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>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

Reply to this Message