![]() ![]() Of course, Excel being Excel, the float used is different depending on the platform: (also some versions of Excel think 1900 was a leap year, others know better - this is a very deep rabbit hole.). This means your gene names are turned into floats (which is Excel's underlying representation of dates). Once mangling has occurred, correction needs to be approached carefully - the main issue with what Excel does here is that it changes the underlying data, rather than only changing things in the display layer. Gene name columns should be set to 'Text', then the septins etc will be left unmolested. ![]() The default for all columns is 'General' - this will lead to the inevitable auto-correct mangling. When importing your delimited data into Excel, be sure to set the column type appropriately. If we assume that Excel is an unavoidable evil (and for most this is unfortunately a credible assumption). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |