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?

"T. Valko" wrote:

Try using EditReplace

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

Repeat for false
Replace with: 0

--
Biff
Microsoft Excel MVP


"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