software

I am try to get a cell to only show quot;P3quot;If some one was to type a one, two or
three diget number then it would look like quot;P3 the number typedquot; for example
if some one typed 12, it would look like quot;P3 12quot; If some one typed 100 it
would look like quot;P3 100quot; It would be for a template. Any Ideas?

If you just want it to show on the template, you can use the following custom
format in the cell:
quot;P3 quot; #
That will show what you want, and the value in the cell will still be a
number.

Hope this helps,
Miguel.

quot;Big Abalonequot; wrote:

gt; I am try to get a cell to only show quot;P3quot;If some one was to type a one, two or
gt; three diget number then it would look like quot;P3 the number typedquot; for example
gt; if some one typed 12, it would look like quot;P3 12quot; If some one typed 100 it
gt; would look like quot;P3 100quot; It would be for a template. Any Ideas?



quot;Miguel Zapicoquot; wrote:

gt; If you just want it to show on the template, you can use the following custom
gt; format in the cell:
gt; quot;P3 quot; #
gt; That will show what you want, and the value in the cell will still be a
gt; number.
gt;
gt; Hope this helps,
gt; Miguel.
gt;
gt; quot;Big Abalonequot; wrote:
gt;
gt; gt; I am try to get a cell to only show quot;P3quot;If some one was to type a one, two or
gt; gt; three diget number then it would look like quot;P3 the number typedquot; for example
gt; gt; if some one typed 12, it would look like quot;P3 12quot; If some one typed 100 it
gt; gt; would look like quot;P3 100quot; It would be for a template. Any Ideas?

OK, great. Then I could have blank cells with that formula in the range and
if I typed quot;p123 it would come out as quot;P 123quot; .............?

Well, this is a cell format that affect how numbers are displayed, not a
formula. What this means is that the entry of the cell is a number it will
come out as quot;P3 numberquot;; the content of the cell is still a number.
If you want to affect how a cell display text, the custom format will be
something like this:
quot;P3 quot;#;;;quot;P quot;@
This will add quot;P quot; to any text value (like p123 entered in the cell will
display P p123)

The important thing here is that the contents of the cell are unchanged, so
even if you see P3 123 in reality the cell has the value of 123. If you want
later to effectively add anything, you can use simple formulas as:
=quot;P quot; amp; A1
This is the reason why my response started with quot;if you just want to showquot;,
as the actions proposed were not aimed to change the data itself, but the way
it is presented.

I don't know if I have clarified or confused more with all those
explanations
Miguel.

quot;Big Abalonequot; wrote:

gt;
gt;
gt; quot;Miguel Zapicoquot; wrote:
gt;
gt; gt; If you just want it to show on the template, you can use the following custom
gt; gt; format in the cell:
gt; gt; quot;P3 quot; #
gt; gt; That will show what you want, and the value in the cell will still be a
gt; gt; number.
gt; gt;
gt; gt; Hope this helps,
gt; gt; Miguel.
gt; gt;
gt; gt; quot;Big Abalonequot; wrote:
gt; gt;
gt; gt; gt; I am try to get a cell to only show quot;P3quot;If some one was to type a one, two or
gt; gt; gt; three diget number then it would look like quot;P3 the number typedquot; for example
gt; gt; gt; if some one typed 12, it would look like quot;P3 12quot; If some one typed 100 it
gt; gt; gt; would look like quot;P3 100quot; It would be for a template. Any Ideas?
gt;
gt; OK, great. Then I could have blank cells with that formula in the range and
gt; if I typed quot;p123 it would come out as quot;P 123quot; .............?