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