View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Will Will is offline
external usenet poster
 
Posts: 129
Default 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