I need to manually enter a list of six-digit codes in a column. Each code starts with the same two-number prefix, 03.  e.g.:  030144 030289 030283   Is there a way that I can type just the last four digits of the code but have the cell AND formula bar show the full six-digit code?  In other words, a custom number format will not do because the full six-digit code won't be displayed in the formula bar.
In column B I have contact number. I want to add a country code to all of them.  For example, if the number is 123456, I want it to become 88123456.    Each number is in 1 row, and there are about a thousand of them, so I want an automatic way to do this that allows me to add the country code to each of them without a space.
Lets say I'm building a base class which will be extended upon by the children class. So a base class is called Base and children can be Child1, Child2, etc.  In the base class's constructor, how can i get the value of Child1/Child2?  This is all using PHP I seem to have screwed up something that allows you to inset evenly, I think I have tried every combination of settings in inset and pivot center and even is far from even.  I tried uninstalling and re installing blender 2.71 and get the same result.  The image attached is a simple default cube that I tried to inset evenly.  I have also attached the blend file link  help?? According to      there         adverb          in or at that place (opposed to here ):      She is there now.         pronoun          (used to introduce a sentence or clause in which the verb comes before its subject or has no complement):      There is no hope.   Then, what element is there in:     There is the man.   I'm confused because "There is the man" is an adverb inversion, in which there is an adverb and "the man is" is inverted. But according to the definition above, there suddenly becomes a pronoun. Passive POE: Need 5V @ 2A at the destination How do you transition from 1-page dungeon map to battle mat? I have a bunch of different ways I use to make maps for my tabletop game.  Sometimes I draw one on graph paper.  Sometimes I use .  Sometimes I copy a map from a published adventure or use the  random generators.  These all have the same output:  a piece of paper (or maybe two) with a map on it, and the map is usually quarter inch squares, or so.  When it's time to put minis on a mat, though, I need to copy over the relevant details of the map to our battle mat.  (We use Tact-Tiles.)  This is fine when most of our map is overland detail and I'm just copying down one or two rooms in which combat will occur.  For dungeon crawls, where there are more random encounters or where combat can chase through many rooms, it can lead to a pretty tedious drawing of the whole dungeon as we go.  I feel foolish for having to ask, but is there some trick, technique, or something to make it less tedious to transcribe maps from printed pages to the battle mat?  EDIT:  Answers in general are great, but I should note that the best answers, for me, will be informed by this previously-unmentioned fact:  the game venue is not my house, so I have limited prep time on site. Spatial reference for dummies? Can anyone recommend a good reference or tutorial that explains the principles of spatial references, projections, and coordinate systems?   We are a small team of programmers working with GIS technology, and we often get snagged when working with data in different SRS/CS because we don't understand the concepts. Why can't I join a friend's world on Minecraft PE? I'm on my tablet playing Minecraft PE. My boyfriend rang me and asked me to join his Minecraft PE world. However, I can't do it because the game doesn't show his world. What's wrong and how can I fix it? Why is the node editor showing different kinds of nodes? How do I evaluate $\sum_{k=0}^{n} {n \choose k}{m \choose k}$ for a given $n$ and $m$.  I have tried to use binomial expansion and combine factorials, but I have gotten nowhere. I don't really know how to start this problem.  The answer is ${n+m \choose n}$. Any help is greatly appreciated.  EDIT: I'm looking for  a proof of this identity. Should I flag obviously wrong answers as NAA? Classical limit of quantum mechanics I have heard that one can recover classical mechanics from quantum mechanics in the limit the $\hbar$ goes to zero.  How can this be done?  (Ideally, I would love to see something like: as $\hbar$ goes to zero, the position wavefunction reduces to a delta function and that the Schrodinger equation/Feynman path integral reduces to the Newtonian/Lagrangian/Hamiltonian equations of motion.) Is it possible to add new predictions/autofill in Overleaf? For example, when I use the command (in Overleaf/ShareLaTex):  \begin{figure}[H]     \centering     \includegraphics{some_graphic}     \caption{some_caption}     \label{fig:some_label} \end{figure}   the \includegraphics{} comes without the [] parameter to change the size of the image, and \begin{figure} without the [H] option by default.   Is it possible to renew the command to make it default? By that I mean that when I type the \begin{figure} command it adds the [H] and [h] as well as [width=\textwidth] in the \includegraphics command, rather than making a global change in the preamble e.g. Whats this white stuff on my board? Alternatives to "and/or"? Functions that are sets of all function - proofs I'm going through the book Proofs and fundamentals, by Bloch, and it doesn't include a solution manual for it's examples. It doesn't have many examples on notation and proof strategy for certain cases, so I needed a little help.    Although I understand the idea, and can draw it out, I'm not sure how to write it in decent proof notation. Any help would be appreciated!   Edit: apologies, my idea is this: theres some function in $F(C,A\times B)$ such that theres some $x$ within $C$ that means $g(x)$ is within $A\times B$. Similarly, the second two imply that for some function within $F(A,C)$ there exists a value $x$ such that $g(x)=C$. and similarly for the third part from $B\rightarrow C$. It's easy to see with drawing it out that these two are the same because one will have a part within A and the other will lead to a part within $B$, so their cross will be the same. I wanted to go about proving it by setting a function $f$ within $F(C,AxB)$ and then working from there, but I really have no idea where to start or the notation. Why does `ls -d *[!e]*` display all files instead of omitting all files that contain an e? ls -d *e* prints out all files containing an "e" somewhere in it. But the opposite, ls -d *[!e]* does not seem to work. Why exactly is that?  is it because ls takes * as its own argument and expands all the files?  I understand I can do: ls -d !(*e*) (in Bash with extglob set, or in ksh). pure code formatting, to enhance a question, is impossible (without 2k rep) How do you check the windows version in Win32 at runtime? How do you check the windows version in Win32 at runtime? Is floating point math broken? Evaluate Current User for Flow - 15 - 18 digit User ID I need to evaluate the current user running a flow. Someone suggested I use the Global Variable {!User.Id}, but it's returning a 15 digit Id. I need to compare the current user with the Account owner. The Account Owner field is returning an 18 digit id. Is there another way to evaluate the current user in my flow and compare it to an Account owner?   The above resolution doesn't really work for my purposes for evaluating a user if I can't compare the user to the Account Owner ID. In the above example, the Account Owner will never = the current user as it is comparing a 15 digit id to a 18 digit id.  Is there a way turn the User ID from the Global Variables into 18 digits? Or vice versa, make the Account Owner ID return as 15 digits? Thanks so much!