Function to control how data displayed

[LOgle5318]

I have 2 columns that I exported from Access to Excel. In Access the columns were Yes or No. In excel they display as True or False. I want them to show as Yes or No what is the function to make this happen?

Thank you!!

[Henry]

LOgle5318,

Assuming your True and False are in columns A & B then
In C1 put
=IF(A1="True","Yes")
and in D1 put
=IF(B1 ="False","No")
Copy these down the columns as far as you need to.
Hide columns A & B.

Henry

"LOgle5318" <[email protected]> wrote
in message news:[email protected]...
>
> I have 2 columns that I exported from Access to Excel. In Access the
> columns were Yes or No. In excel they display as True or False. I want
> them to show as Yes or No what is the function to make this happen?
>
> Thank you!!
>
>
> --
> LOgle5318
> ------------------------------------------------------------------------
> LOgle5318's Profile:
> http://www.excelforum.com/member.php...o&userid=26591
> View this thread: http://www.excelforum.com/showthread...hreadid=398606
>