this post was submitted on 09 Aug 2024
59 points (98.4% liked)
Cybersecurity
5945 readers
104 users here now
c/cybersecurity is a community centered on the cybersecurity and information security profession. You can come here to discuss news, post something interesting, or just chat with others.
THE RULES
Instance Rules
- Be respectful. Everyone should feel welcome here.
- No bigotry - including racism, sexism, ableism, homophobia, transphobia, or xenophobia.
- No Ads / Spamming.
- No pornography.
Community Rules
- Idk, keep it semi-professional?
- Nothing illegal. We're all ethical here.
- Rules will be added/redefined as necessary.
If you ask someone to hack your "friends" socials you're just going to get banned so don't do that.
Learn about hacking
Other security-related communities [email protected] [email protected] [email protected] [email protected] [email protected]
Notable mention to [email protected]
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Look, no one is gonna come out of this one clean. Crowdstrike dropped the fucking ball, but Delta's dev team appears to be completely made up by nephews of executives who say they're geniuses because they're great with Excel
Dont underestimate Excel
"Fuck your leading zeros."
-Excel
You have to set the cell as text rather than a number.
I wonder if you can format a cell with a custom number type to have leading zeros...
Making it text means it is something other than a number, but generally it has already screwed up the leading zeros by the time you have the opportunity to make it text.
You can set a special format if all the numbers are the same number of characters, but not for something like 0043 and 05467.
Thanks for the info.
I had the leading zero issue importing a CSV so I couldn't set the cell type so I see your point.