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 got the result I wanted using the DEC2BIN and MID functions. Piece of cake once one figures out the formula to use. Running totals within the octet with SUMIF function. Now I'm trying to find the video by the Aussie I viewed last night on how to merge and center without the merge and center function.