59
you are viewing a single comment's thread
view the rest of the comments
[-] IllNess@infosec.pub 1 points 3 months ago

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

[-] snooggums@midwest.social 3 points 3 months ago

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.

[-] IllNess@infosec.pub 2 points 3 months ago

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.

this post was submitted on 09 Aug 2024
59 points (98.4% liked)

Cybersecurity

5754 readers
108 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

Community Rules

If you ask someone to hack your "friends" socials you're just going to get banned so don't do that.

Learn about hacking

Hack the Box

Try Hack Me

Pico Capture the flag

Other security-related communities !databreaches@lemmy.zip !netsec@lemmy.world !cybersecurity@lemmy.capebreton.social !securitynews@infosec.pub !netsec@links.hackliberty.org !cybersecurity@infosec.pub !pulse_of_truth@infosec.pub

Notable mention to !cybersecuritymemes@lemmy.world

founded 1 year ago
MODERATORS