Function to control how data displayed
 

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

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" wrote
in message ...

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