I need to write binary data in 64 bits like 0000000000000010, 0000000000000011 etc, but when I write them, it gets automatically converted to 10, 11 respectively. Also, when I write a huge number, like 100000000000 it gets converted to 1E+11.
How can I stop excel from converting? I would need to show them in all 64 binary digits only and not in abbreviated form.
Best Answer
You can select the cells in your worksheet, right click and select "Text" from the list of category, click ok and you are ready to insert the binary numbers that you want.