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