True/False : 1/0

[Guest]

Hi,

I'm sure this is a simple query, but can you convert true/false returns into
1/0? I have a page full of either "true or false"'s, and it is much easier to
see where you are if you are just dealing with 1 or 0's.

Thanks,

Will

 

[Dave Peterson]

Maybe a couple of Edit|Replaces would be the simplest way to convert them.

 

[Guest]

Dave,

Thanks for the reply, but these values will be constantly changing so it
needs to be dynamic.

Will

 

[Niek Otten]

=IF(YourOriginalFormula,1,0)

 

[Guest]

Will,
In Excel, multiply by 1 to change to numeric value

e.g in b1 put =a1*1

in VBA multiply by -1!

HTH

 

[Guest]

If TRUE/FALSE come out of an expression like:
=(1=1) this always gives true, then use:
=--(1=1) will convert to a number