Forum Discussion
Solved
Decimal to Binary
I am trying to create a spreadsheet that takes an Decimal IP address and populates individual cells within the octets with the binary value equivalents. I need to keep a running value total based on ...
Thanks for this. It worked like a champ. Can you direct me to where I could read a bit about what the +0 is doing for me.
Have a great weekend and again, thanks.
TAPS
I spoke to soon. Cells B8:B9 are populated with the MID function. The value in both cells is 1. I run an AND on the two cells and get an error that "A value used in the formula is of the wrong data type". I was feeling good for a bit and I did find Wyn's video to answer my other question.