When processing microarray data sets, we recently noticed that some gene names were being changed inadvertently to non-gene names.
A little detective work traced the problem to default date format
conversions and floating-point format conversions in the very useful Excel program
package. The date conversions affect at least 30 gene names; the floating-point
conversions affect at least 2,000 if Riken identifiers are included. These conversions
are irreversible; the original gene names cannot be recovered.
Users of Excel for analyses involving gene names should be aware of this problem, which can cause genes, including medically important ones, to be lost from view and which has contaminated even carefully curated public databases. We provide work-arounds and scripts for circumventing the problem.
Some files in PDF format and require Adobe Acrobat Reader to be viewed. Click here to download.
This web site is a development of the Genomics and Pharmacology Facility, Developmental Therapeutics Branch (DTB), Center for Cancer Research (CCR), National Cancer Institute (NCI).