ExcelBanter - format cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - format cell (https://www.excelbanter.com/excel-discussion-misc-queries/156099-format-cell.html)

chill

format cell

hi
anybody who knows what format i need to present an IP address in binary
format like 11111111.11111111.11111100.00000000 ?

thanks

format cell

Text.
exccel will only accept 16 digits as numbers

"chill" wrote:

hi
anybody who knows what format i need to present an IP address in binary
format like 11111111.11111111.11111100.00000000 ?

thanks

All times are GMT +1. The time now is 05:50 PM.