Function to control how data displayed

L

LOgle5318

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

Thank you!
 
H

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
 
Top