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