An nameless reader shares a report: In 2020, scientists determined simply to remodel the alphanumeric symbols they used to symbolize genes reasonably than attempt to cope with an Excel characteristic that was decoding their names as dates and (un)helpfully reformatting them mechanically. Final week, a member of the Excel group posted that the corporate is rolling out an replace on Home windows and macOS to repair that. Excel’s computerized conversions are meant to make it simpler and quicker to enter sure forms of generally entered information — numbers and dates, for example. However for scientists utilizing fast shorthand to make issues legible, it might destroy printed, peer-reviewed information, as a 2016 examine discovered.
Microsoft detailed the replace in a weblog publish final week, including a checkbox labeled “Convert steady letters and numbers to a date.” You may most likely guess what that toggles. The replace builds on the Automated Knowledge Conversions settings the corporate added final 12 months, which included the choice for Excel to warn you when it is about to get additional useful and allow you to load your file with out computerized conversion so you possibly can guarantee nothing can be screwed up by it.
