Recovering lost data due to text-formatting?
August 10, 2011 6:30 AM Subscribe
Asking for a friend:
I was entering some data into excel and I realized it was changing gene names into dates. E.g. there is a gene in my dataset called SEPT5 and Excel automatically makes this into Sep-05. If I manually set the column as text, it inexplicably changes the cell to a 5-digit number that represents that date, in this case 38596.
posted by empath to computers & internet (21 answers total) 3 users marked this as a favorite
I would simply discontinue using Excel, but my collaborators will not.
Any suggestions for recovering the gene names that were changed? Googling the problem presents a lot of options, but most of them are "format the cell beforehand" and that's not an answer to my problem.
(And it actually changes the DATA not just what is displayed)