Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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? -- David Biddulph "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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! "Vivek" schreef in bericht ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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 "David Biddulph" wrote: 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? -- David Biddulph "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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
Thanks Frederik,
That helped. Regards, "Frederik" wrote: 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! "Vivek" schreef in bericht ... 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert Boolean true-false to zero's and ones
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRUE - Boolean vs. Text | Excel Worksheet Functions | |||
Boolean 0/1 instead of True/False | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
How can you convert the false/true into 1/0 in Excel? | Excel Worksheet Functions | |||
Convert TRUE/FALSE results to a number | Excel Worksheet Functions |