Excel no longer messes things up for scientists trying to store genetic codes in a spreadsheet

Double exposure of creative DNA hologram on laptop background
(Image credit: Igor Kutyaev via Getty Images)

Excel is one of the programs that gets used in a multitude of sectors, from banking and finance, to engineering and medicine. In the case of the latter, geneticists routinely struggled with the program's habit of converting text into a date, causing gene naming errors to crop up in research papers.

Well, it's taken years to happen but Microsoft has finally updated Excel to solve this issue once and for all.

As reported by the Verge, the original problem wasn't as mundane as you might expect. If your work involves entering thousands of gene codes into a spreadsheet, you'd want it to handle them all correctly. However, prior to this update, Excel would automatically convert text entries into a date, if the code looked similar to one.

The solution used to be reformatting the cells to prevent this from happening but if the spreadsheet is then saved as a type that doesn't retain the formatting, then the next person to use that data will open it up and get a bunch of dates.

Given the amount of research in genetics undertaken around the world, simple errors like this can easily grow to become a widespread and potentially harmful problem. The scientific community in question eventually resorted to altering the renaming of a number of human genes to prevent the situation from getting worse.

In a blog posted last week, Microsoft showed that it had finally responded to feedback from Excel users and released an update to the Windows and MacOS versions that allows you to disable the automatic renaming system.

(Image credit: Microsoft)

If you're using the latest version of Excel, simply click File and then Options, in the bottom left-hand corner. Choose Data in the menu and you should see the new Automatic Data Conversion options. Uncheck the very last one and you're good to go!

It's worth noting that Google Sheets will also convert text entries into a date, if it looks like one, and the only way around this is to format the column or row as text before you enter any data.

Now before you think that all of this is just making a mountain out of molehill, the automatic data conversion problem in Excel was highlighted as far back as 2016. That means it's taken Microsoft seven years to acknowledge and ultimately address the issue. And the solution was such a simple one, too, so goodness knows why it took so long to come about.

It makes waiting a month or two for a critical game patch to be released look like a blink of an eye, by comparison.

Best gaming monitorBest high refresh rate monitorBest 4K monitor for gamingBest 4K TV for gaming


Best gaming monitor: Pixel-perfect panels.
Best high refresh rate monitor: Screaming quick.
Best 4K monitor for gaming: High-res only.
Best 4K TV for gaming: Big-screen 4K PC gaming.

Nick Evanson
Hardware Writer

Nick, gaming, and computers all first met in 1981, with the love affair starting on a Sinclair ZX81 in kit form and a book on ZX Basic. He ended up becoming a physics and IT teacher, but by the late 1990s decided it was time to cut his teeth writing for a long defunct UK tech site. He went on to do the same at Madonion, helping to write the help files for 3DMark and PCMark. After a short stint working at Beyond3D.com, Nick joined Futuremark (MadOnion rebranded) full-time, as editor-in-chief for its gaming and hardware section, YouGamers. After the site shutdown, he became an engineering and computing lecturer for many years, but missed the writing bug. Cue four years at TechSpot.com and over 100 long articles on anything and everything. He freely admits to being far too obsessed with GPUs and open world grindy RPGs, but who isn't these days? 

Read more
A promotional image for Microsoft OneDrive, showing a stylized collage of a tablet, phone, and application icons together
About darn time: Microsoft says it has fixed the annoying lag in Windows Explorer when working with cloud-based files
Microsoft's Task Manager in Windows 11
After years of complaints about Windows Task Manager displaying CPU utilization incorrectly, a fix is finally on its way
A photo of the Windows update menu, showing that I'm all up to date
Latest Windows 11 Insider Build fixes 24H2 update's most annoying issues, including Auto HDR bugs and mouse stuttering
Michael Jarman holds his Excel championship belt aloft.
'Super Bowl for Excel nerds' crowns the king of the spreadsheets in Vegas, complete with championship belt and adoring crowd: 'You'd never see this with Google Sheets'
A close-up view of the battery life indicator in Windows 11
Color-coded battery icon update for Windows 11 should've been super simple, proves to be anything but
Microsoft Copilot
A rather pleasing Windows 11 update bug automatically uninstalls Copilot and unpins it from the taskbar, which is jolly nice of it
Latest in Hardware
A woman wearing a VR headset with dramatic, colourful lighting across the background
'World’s smallest LEDs' could lead to accurately lit screens with 127,000 pixels per inch and much more immersive VR
The NES themed 8BitDo Retro mechanical gaming keyboard on a blue background
I love the 8BitDo Retro C64 keyboard but I'd pick its cheaper NES-themed model near its lowest price ever during Amazon's Big Spring Sale
The snazzy red and black HyperX Cloud Alpha wireless headphones float in a teal void. The microphone is attached to the headset.
The best wireless gaming headset is now even better in the Amazon Big Spring Sale, boasting a more than $50 discount
A chip being held up in an Intel fab
Intel is reportedly 'working to finalize commitments from Nvidia' as a foundry partner, suggesting gaming potential for the 18A node
Amazon box
Don't panic! The 'Do Not Send Voice Recordings' option Amazon just removed was only used by 0.03% of customers and they can still have it
Digital generated image of people surrounded by interactive transparent and glowing panels with data. Visualising smart technology, blockchain and artificial intelligence
Now I shall demand the cookies! Proposed new browsing agreement turns the tables and lets users dictate terms to websites
Latest in News
Lara Croft Unified Art
Tomb Raider developer Crystal Dynamics lays off 17 employees 'to better align our current business needs and the studio's future success'
A long bendy arm stealing money from people in a subway car
'You're a very long arm. You steal things. It's a comedy game,' explains developer of comedy game where you steal things with a very long arm
The heroes are attacked by monsters
Pillars of Eternity is getting turn-based combat to mark its 10th anniversary, and that means PC Gamer editors will soon be arguing about combat mechanics again
Image of Ronaldo from Fatal Fury: City of the Wolves trailer
It doesn't really make sense that soccer star Ronaldo is now a Fatal Fury character, but if you follow the money you can see how it happened
Junah beginning a battle in Metaphor: ReFantazio.
Today's RPG fans are 'very sensitive to feeling like they wasted time' when they die, says Metaphor: ReFantazio battle planner—but Atlus still made combat hard anyway
Image of Cersei Lanniser from Game of Thrones: Kingsroad Steam early access trailer
A new Game of Thrones RPG is coming to Steam today with a cast of 'familiar faces,' which is good because it's really the only way to tell it's a GoT game at all