{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 虎瘦雄心在 的问题《How can I recover “raw” data from an excel spreads》','https://www.manongdao.com/q-1063339.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have the following problem:
Part number: 625009E11
Excel rep: 6.25009E+16
I want to recover the original information. Is this possible? Or, does Excel automatically dump the original data if it can format things as a number? (I also have another, similar, problem with leading zeroes.)
You might be able to recover part numbers with some clever scripting, but for leading zeroes you're pretty much screwed. Excel "helpfully" tries to cast strings it recognizes as other data types and does not keep a copy of the original. This has been a known problem for almost a decade, especially in bio research: http://www.biomedcentral.com/1471-2105/5/80
Don't use Excel as a database, kids.