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!

"Dave Peterson" wrote:

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