Agent641@lemmy.world to Programmer Humor@lemmy.ml · 5 months agowhen you import some data into Excel and it tries to format all your number fieldslemmy.worldimagemessage-square13fedilinkarrow-up124
arrow-up124imagewhen you import some data into Excel and it tries to format all your number fieldslemmy.worldAgent641@lemmy.world to Programmer Humor@lemmy.ml · 5 months agomessage-square13fedilink
minus-squarefestus@lemmy.calinkfedilinkEnglisharrow-up0·edit-25 months agoI’m not sure what version got this, but there’s a setting now where you can disable auto-conversion and it’s amazing. https://mashable.com/article/microsoft-excel-disable-setting-auto-conversion-data-into-dates
minus-squareflambonkscious@sh.itjust.workslinkfedilinkEnglisharrow-up1·5 months agoHoly crap, that’s amazing - I can’t believe it would take this long! I presume straight up numbers are no longer affected, too, but I’m almost willing to trust it and try it out…
I’m not sure what version got this, but there’s a setting now where you can disable auto-conversion and it’s amazing.
https://mashable.com/article/microsoft-excel-disable-setting-auto-conversion-data-into-dates
Holy crap, that’s amazing - I can’t believe it would take this long! I presume straight up numbers are no longer affected, too, but I’m almost willing to trust it and try it out…