this post was submitted on 15 Jan 2025
555 points (97.8% liked)
memes
10955 readers
4885 users here now
Community rules
1. Be civil
No trolling, bigotry or other insulting / annoying behaviour
2. No politics
This is non-politics community. For political memes please go to [email protected]
3. No recent reposts
Check for reposts when posting a meme, you can only repost after 1 month
4. No bots
No bots without the express approval of the mods or the admins
5. No Spam/Ads
No advertisements or spam. This is an instance rule and the only way to live.
Sister communities
- [email protected] : Star Trek memes, chat and shitposts
- [email protected] : Lemmy Shitposts, anything and everything goes.
- [email protected] : Linux themed memes
- [email protected] : for those who love comic stories.
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
Wait, so if I were to import a csv with data that would normally be interpreted as a date by excel, but preceded that data with an apostrophe, it would still recognize that as a date? I've never tested this, so I'm not sure.
Relatedly, I know someone who was working some ssn data. Unfortunately, if an SSN started with a 0, it would drop that 0. It was a mess for them. I think there was a recent release that allowed you to not ignore leading 0's.
I've never personally tried adding the ' before you import but the one document that was causing problems with that for me recently was an auto generated document so I couldn't have possibly added any spaces or characters before excel went and messed them up anyways.