View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default convert Boolean true-false to zero's and ones

As a matter of interest, what process did you use for your import? If one
uses Excel to open a text file, it doesn't convert from 1/0 to TRUE/FALSE,
so I wonder what you did that gave those symptoms?
--
David Biddulph

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