I am entering 1044372000263084 into a cell in Excel 2013. When I hit enter the cell is changing to 1.04437E + 15 . The bar above the table shows 104437200063080.   Why is it changing and how can I make it stop?
I'm trying to process some data in Excel. The data includes numeric account numbers and other long numeric strings (like cell phone MEIDs). I am not doing math operations on these strings, so I want Excel to treat them as plain text.  Here is what is making me nuts (this is Excel 2010):   Take a long number like 1240800388917 and paste it in a cell in a new worksheet. Excel's default cell format is general, so the string is presented in scientific notation as 1.2408E+12 Right click on the cell, select Format Cells, set the format to Text   The cell is still displayed in scientific notation, even though the format has been set to text.  Now, if I do the steps in a different order:   Format an empty cell as text. Right click on the cell, select Format Cells, set the format to Text Take a long number like 1240800388917 and paste it in to the text formatted cell   Now, the cell is displayed as a string and not in scientific notation.  The results remaining in scientific notation even though the cell is formatted as text just seems broken to me. I've seen suggested work-arounds like: use CSV import and set the format to text, add a space character to the beginning of each numeric string, and others.  Is there a simple good work around to easily keep these strings formatted as text?  Why on earth does Excel do this?  Related SU questions I found:  and
Appending to the end of a file with NSMutableString "Misaligned partition" - Should I do repartition (how?) I'd like to know if any certificates support a double wildcard like *.*.example.com? I've just been on the phone with my current SSL provider (register.com) and the girl there said they don't offer anything like that and that she didn't think it was possible anyway.   Can anyone tell me if this is possible, and if browsers support this? Say I have a variable named choice it is equal to 2. How would I access the name of the variable? Something equivalent to  In [53]: namestr(choice) Out[53]: 'choice'   for use in making a dictionary. There's a good way to do this and I'm just missing it.  EDIT:  The reason to do this is thus. I am running some data analysis stuff where I call the program with multiple parameters that I would like to tweak, or not tweak, at runtime. I read in the parameters I used in the last run from a .config file formated as  filename no_sig_resonance.dat  mass_peak 700  choice 1,2,3   When prompted for values, the previously used is displayed and an empty string input will use the previously used value.  My question comes about because when it comes to writing the dictionary that these values have been scanned into. If a parameter is needed I run get_param which accesses the file and finds the parameter.   I think I will avoid the problem all together by reading the .config file once and producing a dictionary from that. I avoided that originally for... reasons I no longer remember. Perfect situation to update my code! On really old Ubuntu 6.06 - How to upgrade Do animagi get to pick their animal? Say that I want to become an Animagus, and am really hoping to be a certain animal (say, a stag). I study a whole bunch and manage to perfect the technique. Do I get to pick the animal I wind up as, so that I wind up being a stag like I want? Or is it something where I just find out what I turn into (and if I wind up as a dung beetle, tough luck)?    This is not a duplicate of  because that question is about which animals an Animagus can potentially transform into. Mine is about if I can decide which potential animal I wind up being. df -h - Used space + Avail Free space is less than the Total size of /home As the output of df -h shows here, something is eating up 5GB of free space. So, it's not available to use.   I'm also noticing sometimes that the hard disk gets filled up to 100% sometimes. So, I had to restart the machine or delete some unncessary files. Only noticed these in /home partition. Don't know whether these two are related, but appreciate if anyone can put some insight into this.  $ df -h Filesystem            Size  Used Avail Use% Mounted on /dev/sda8             100G   92G  2.7G  98% /home $\lim_{x \to 0} f(x)=\frac{\tan 3x}{\tan 2x}$ without L'Hospital What can I expect from a Skype interview for PhD admissions? Why did Sirius Black's family live among Muggles? Introductory measure theory textbook I would like to teach myself measure theory and I am looking for a good introductory textbook at the advanced undergraduate or early graduate level. A reader-friendly text with plenty of examples would be ideal. Use of pizza stone in gas oven I have a new gas kitchen stove.  The oven seems to burn so easily. I have a thermometer in there and it is registering the temp that I have the oven set on.  I have seen where people have used a pizza stone to even out the heat.  I want to know if you place a rectangle pizza stone directly on the bottom of the oven or should it be placed on a rack on the lowest setting?  I would appreciate replies from anyone who has used this and if it had helped the problem The first given name of an author or editor in my bibliography should be written out, but all further first names should be abbreviated (initials with a period -- and space if there are multiple first names/initials, see below). I am using style=authoryear with BibLaTeX (v. 2.7) and Biber (v. 1.7).  My bibliography looks like this:     Doe, John Arthur Kyle (2013). The secret life of John Doe.   It should look like this:     Doe, John A. K. (2013). The secret life of John Doe.   Minimal example:  example.tex  \documentclass{scrartcl}  \usepackage[ngerman]{babel} \usepackage[babel,german=quotes]{csquotes} \usepackage[backend=biber,style=authoryear]{biblatex} \bibliography{bibliography}  \begin{document}  \cite[123]{Doe} \printbibliography  \end{document}   bibliography.bib  @book{Doe,     title = {The secret life of John Doe},     author = {Doe, John Arthur Kyle},     year = {2013} }   (Worked with said versions of BibLaTeX and Biber, Texmaker (v. 4.0.3) and MiKTeX (v. 2.9.4813).)  I could not find a solution in biblatex.def and firstinits=true abbreviates all first names, including the first one. What is the Total Reputation field on Area51? What does the total reputation field on Area51 represent?  It's obviously not the total of the user's reputation on the various sites, as that is the number listed as user reputation. How can I see my progress for different badges? I am trying to obtain more badges on Stack Overflow. For example, to gain Archaeologist I need to edit 100 inactive posts but I am not keeping track of the number of posts I've edited. For Deputy I need to raise 80 helpful flags, etc. How can I view all my statistics about the badges, such as how many more edits I need to do, etc. I'm not doing it for badges, but I can spend a bit more effort if I'm close to getting a badge. Prove $\sum{\frac{1}{(x+2y)^2}} \geq\frac{1}{xy+yz+zx}$ Group $G$ of order $p^2$: $\;G\cong \mathbb Z_{p^2}$ or $G\cong \mathbb Z_p \times \mathbb Z_p$ If the order of $G$ is $p^2$ then how do I show that $G$ is isomorphic to $\mathbb Z_{p^2}$ or $\mathbb Z_p\times\mathbb Z_p$. Get total height of webView's content using Javascript How to change the chapter number to display as text (One, Two, ...)? $|p(z)| \leq M$ for $|z| \leq 1$ Show that $|p(z)| \leq M|z|^n$ for $|z| \geq 1$