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
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.