View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Frederik[_3_] Frederik[_3_] is offline
external usenet poster
 
Posts: 63
Default convert Boolean true-false to zero's and ones

Hello

If you multiply the TRUE's and the FALSE's by 1, then you get the 1's and
the 0's back.

Greetings!

"Vivek" schreef in bericht
...
Im importing binary data into excel from matlab. But my zero's an one's
are
automatically converted to true and false...
I know that true=1 and false = 0; but i want to use this zero's and one's
matrix further, but not in excel.

.I am trying to make them binary
numbers again....any suggestions?

Thanks