Agent641@lemmy.world to Programmer Humor@lemmy.ml · 9 months agowhen you import some data into Excel and it tries to format all your number fieldslemmy.worldimagemessage-square13fedilinkarrow-up129
arrow-up129imagewhen you import some data into Excel and it tries to format all your number fieldslemmy.worldAgent641@lemmy.world to Programmer Humor@lemmy.ml · 9 months agomessage-square13fedilink
minus-squarefestus@lemmy.calinkfedilinkEnglisharrow-up0·edit-29 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·9 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…