HootinNHollerin@lemmy.dbzer0.com to Engineering Memes@lemmy.worldEnglish · edit-24 months agoGet Datedlemmy.dbzer0.comimagemessage-square44linkfedilinkarrow-up1679arrow-down112
arrow-up1667arrow-down1imageGet Datedlemmy.dbzer0.comHootinNHollerin@lemmy.dbzer0.com to Engineering Memes@lemmy.worldEnglish · edit-24 months agomessage-square44linkfedilink
minus-squareglimse@lemmy.worldlinkfedilinkEnglisharrow-up20·4 months agoExcel makes some crazy assumptions with dates but…it doesn’t get confused about decimals. I just tried 12.5, 1900.12.5, and 5.12.1900 but none converted to dates
minus-squareUnrepententProcrastinator@lemmy.calinkfedilinkEnglisharrow-up8·4 months agoThe worst culprit for me are the alphanumerical employee codes like “MARC4”
minus-squarejaybone@lemmy.worldlinkfedilinkEnglisharrow-up3·4 months agoIs that the code for the employee who rats out your stash?
minus-squareglimse@lemmy.worldlinkfedilinkEnglisharrow-up1·4 months agoYeahhhh I’ve had similar things happen with device SKUs! It gets confused with letters a lot
minus-squareFushuan [he/him]@lemm.eelinkfedilinkEnglisharrow-up2·4 months agoAs someone from Spain, excel decimals are the bane of my fucking existence
Excel makes some crazy assumptions with dates but…it doesn’t get confused about decimals. I just tried 12.5, 1900.12.5, and 5.12.1900 but none converted to dates
The worst culprit for me are the alphanumerical employee codes like “MARC4”
Is that the code for the employee who rats out your stash?
Yeahhhh I’ve had similar things happen with device SKUs! It gets confused with letters a lot
Could be worse
As someone from Spain, excel decimals are the bane of my fucking existence