misk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 year agoMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.comexternal-linkmessage-square86fedilinkarrow-up1400arrow-down16
arrow-up1394arrow-down1external-linkMicrosoft fixes the Excel feature that was wrecking scientific datawww.theverge.commisk@sopuli.xyz to Technology@lemmy.worldEnglish · 1 year agomessage-square86fedilink
minus-squaremacrocephalic@lemmy.worldlinkfedilinkEnglisharrow-up39arrow-down2·1 year agoNow if only it would stop dropping leading zeros unless you ask it, and we got rid of the MM/DD/yyyy date format entirely.
minus-squaretheparadox@lemmy.worldlinkfedilinkEnglisharrow-up8·1 year ago Now if only it would stop dropping leading zeros unless you ask it That appears to actually be a feature.
minus-squaremacrocephalic@lemmy.worldlinkfedilinkEnglisharrow-up1·1 year agoHoly shit! Now I just need to talk to some sysadmins and get some group policies set.
minus-squareEtterra@lemmy.worldlinkfedilinkEnglisharrow-up6arrow-down6·1 year agoMM/DD/YYYY is the correct format here in America.
minus-squareEngineerGaming@feddit.nllinkfedilinkEnglisharrow-up11arrow-down2·1 year agoI think the point was that the format itself is odd. I am European and it’s weird to me: logically it should be either from greatest to smallest, or from smallest to greatest, not a weird in-between.
minus-squareatzanteol@sh.itjust.workslinkfedilinkEnglisharrow-up2·1 year agoLogically it would be milliseconds since 1970.
minus-squaremacrocephalic@lemmy.worldlinkfedilinkEnglisharrow-up1·1 year agoNot very good for birthdates.
Now if only it would stop dropping leading zeros unless you ask it, and we got rid of the MM/DD/yyyy date format entirely.
That appears to actually be a feature.
Holy shit! Now I just need to talk to some sysadmins and get some group policies set.
MM/DD/YYYY is the correct format here in America.
I think the point was that the format itself is odd. I am European and it’s weird to me: logically it should be either from greatest to smallest, or from smallest to greatest, not a weird in-between.
Logically it would be milliseconds since 1970.
Not very good for birthdates.