Post AynQDhxLw2mfeNHfLU by clacke@libranet.de
 (DIR) More posts by clacke@libranet.de
 (DIR) Post #AynQDhxLw2mfeNHfLU by clacke@libranet.de
       2025-10-02T10:42:21Z
       
       1 likes, 0 repeats
       
       An IPv4 number where all bytes are three digits in decimal is treated by Excel as ... a decimal number with thousand-separator periods. 🤦How did I never fall into this trap before? 😅
       
 (DIR) Post #AynQhPXqx6s3EhWJKi by clacke@libranet.de
       2025-10-02T10:46:40Z
       
       0 likes, 0 repeats
       
       I guess I'm more Excel-heavy this year than I've ever been, so it does make sense that I would have been spared before.It was very jarring to see one IP address out of a bunch turn into 1.76E+11. 🤣
       
 (DIR) Post #AynQzBfPI1hbPFWu6S by grumpysmiffy@aus.social
       2025-10-02T10:49:30Z
       
       1 likes, 0 repeats
       
       @clacke I can only ask: *why is even Excel*?
       
 (DIR) Post #AynS4GSR0NWxfORlnU by clacke@libranet.de
       2025-10-02T11:00:29Z
       
       0 likes, 0 repeats
       
       @galaxis Right, I wouldn't have run into it unless numbers were formatted in French! I didn't even think of that.
       
 (DIR) Post #Ayo5ROZGuiWNh1fK6K by zeborah@mastodon.nz
       2025-10-02T18:24:15Z
       
       1 likes, 0 repeats
       
       @clacke Argh this happens to library barcodes and ISBNs *all* the time, it's an absolute PITA. There should be a setting when you launch Excel for the first time to say "No I'm not an astronomer or whatever, I actually want to keep all my digits. All of them. Forever."