convert Boolean true-false to zero's and ones

[Guest]

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

 

[T. Valko]

Try using Edit>Replace

Select the cells in question
Goto the menu Edit>Replace
Find what: true
Replace with: 1
Replace All

Repeat for false
Replace with: 0

 

[Guest]

Thanks! I am happy to see my data back....
Though, ive to manually do it, is there any condition i can set up for
automatic conversion?

 

[David Biddulph]

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?

 

[Frederik]

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!

 

[Dave Peterson]

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.

 

[Guest]

Hi David,

I didnt import data into Excel. I am actually working in Matlab software and
exporting data from Matlab to MS Excel.

Thanks for responding..
Regards

 

[Guest]

Thanks Frederik,

That helped.
Regards,

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!

 

[Guest]

This is amazing! That worked very easily. But i didnt uncheck, infact i
Checked "transition formula evaluation" to get zero's and one's back.

Thanks!