IP Address support in spreadsheets?

[Bryan Fields via NANOG <nanog () lists nanog org>]

Has anyone found a solution to represent IPv4 addresses in a spreadsheet, 
preferably Google Sheets?  I'm not here to debate the use of spreadsheets for 
tracking IP addresses, just find something better than storing v4 dotted 
decimal as text in a spreadsheet.  We don't need v6 at this time; we're using 
a spreadsheet for tracking addressing, v6 is beyond us.

At minimum we need to store it as a 32 bit INT, and display as dotted decimal. 
 If there's some way to make it aware of subnet slash notation, so much the 
better.  I'm a bit at a loss as to why there's no IPv4 number format with how 
often spreadsheets are the source of truth in some rather large service providers.

Again, not looking for non-spreadsheet solutions to this, and ideally a web 
interface spreadsheet would be best for sharing.  We don't need a real 
database if it's on the web :-)

--
Bryan Fields

727-409-1194 - Voice
http://bryanfields.net

_______________________________________________
NANOG mailing list 
https://lists.nanog.org/archives/list/nanog () lists nanog org/message/VDO2LGNHKC3XXZQEL2ATCRELA6RUFY5H/