Tag Archives: date formatting

The error made in 20% of papers on genes …

Posted on September 23, 2016 by dougaj4

… and how to avoid it. According to a recent scientific paper “Gene name errors are widespread in the scientific literature” (authors: Mark Ziemann, Yotam Eren1, and Assam El-Osta).  The paper says that “approximately one-fifth of papers with supplementary Excel gene lists contain erroneous gene … Continue reading →

Posted in Excel | Tagged , , , , | Leave a comment

Dealing with dates -1, date values and formats

Posted on June 6, 2015 by dougaj4

Following a discussion at Eng-Tips, I have been having a closer look at how Excel handles the entry and display of dates.  The Eng-Tips discussion concerned changes to data when csv files are opened in Excel.  I will deal with that (together with … Continue reading →

Posted in Excel | Tagged , , , , , | 4 Comments