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