True/False Expressions

[Hetman]

I am importing data from Access 2010 into Excel 2010. My boolean expressions are showing as True/False in Excel even though they are 1/0 in Access. How do I change these to 1/0 in Excel as all my formulas are set to read 1/0.

[NBVC]

Can you do a Find/Replace?

CTRL+H

Find: TRUE
Replace with 1

then again

Find: FALSE
Replace with 0

[steve.m]

Put your formula in an “=if(formula=TRUE,1,0)”