convert Boolean true-false to zero's and ones
If you see 1 or 0 in the cell, but true/false in the formula bar, this may work:
Tools|Options|Transition tab (xl2003 menu system)
Uncheck "transition formula evaluation"
In fact, I'd uncheck all those lotus 123 transition settings.
Vivek wrote:
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
--
Dave Peterson
|