HootinNHollerin@lemmy.dbzer0.com to Engineering Memes@lemmy.worldEnglish · edit-27 days agoGet Datedlemmy.dbzer0.comimagemessage-square43fedilinkarrow-up1670arrow-down112
arrow-up1658arrow-down1imageGet Datedlemmy.dbzer0.comHootinNHollerin@lemmy.dbzer0.com to Engineering Memes@lemmy.worldEnglish · edit-27 days agomessage-square43fedilink
minus-squareglimse@lemmy.worldlinkfedilinkEnglisharrow-up20·7 days 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·7 days agoThe worst culprit for me are the alphanumerical employee codes like “MARC4”
minus-squarejaybone@lemmy.worldlinkfedilinkEnglisharrow-up3·7 days agoIs that the code for the employee who rats out your stash?
minus-squareglimse@lemmy.worldlinkfedilinkEnglisharrow-up1·7 days agoYeahhhh I’ve had similar things happen with device SKUs! It gets confused with letters a lot
minus-squareFushuan [he/him]@lemm.eelinkfedilinkEnglisharrow-up2·6 days 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?
Could be worse
Yeahhhh I’ve had similar things happen with device SKUs! It gets confused with letters a lot
As someone from Spain, excel decimals are the bane of my fucking existence