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-squareDacoTaco@lemmy.worldlinkfedilinkEnglisharrow-up2arrow-down1·edit-26 days agoYou most certainly can. You can set the format of a cell, and if its set to number 12.5 will be 12.5, it wont even try date formats…
minus-squarepyre@lemmy.worldlinkfedilinkEnglisharrow-up3arrow-down1·6 days agothey’re talking about defaults, as in when you create a new file the first thing you do is type a number and not get interpreted as a date.
minus-squareFushuan [he/him]@lemm.eelinkfedilinkEnglisharrow-up1·6 days agoTry opening a sheet sent by a Spaniard colleague. Good luck with decimals.
minus-squareDacoTaco@lemmy.worldlinkfedilinkEnglisharrow-up1·6 days agoThats a locale issues that excel has and cant fix ( for compatibility reasons ). Its one of the reasons i hate excel haha. But not related to cell types
minus-squareFushuan [he/him]@lemm.eelinkfedilinkEnglisharrow-up1·6 days agoNo, I know. I can fix it, but old sheets and stubborn colleagues and clients and my fucking grandma won’t. My point was more related with excel manipulating input incorrectly because of Unspecified.
You most certainly can. You can set the format of a cell, and if its set to number 12.5 will be 12.5, it wont even try date formats…
they’re talking about defaults, as in when you create a new file the first thing you do is type a number and not get interpreted as a date.
Try opening a sheet sent by a Spaniard colleague. Good luck with decimals.
Thats a locale issues that excel has and cant fix ( for compatibility reasons ). Its one of the reasons i hate excel haha. But not related to cell types
No, I know. I can fix it, but old sheets and stubborn colleagues and clients and my fucking grandma won’t.
My point was more related with excel manipulating input incorrectly because of Unspecified.