True/False : 1/0
 

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

True/False : 1/0
 

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

will wrote:

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

True/False : 1/0
 

Dave,

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

Will

"Dave Peterson" wrote:

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

will wrote:

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

True/False : 1/0
 

=IF(YourOriginalFormula,1,0)

--
Kind regards,

Niek Otten

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

True/False : 1/0
 

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

e.g in b1 put =a1*1

in VBA multiply by -1!

HTH

"will" wrote:

Dave,

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

Will

"Dave Peterson" wrote:

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

will wrote:

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

True/False : 1/0
 

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


"will" wrote:

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