formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am try to get a cell to only show "P3"If some one was to type a one, two or
three diget number then it would look like "P3 the number typed" for example
if some one typed 12, it would look like "P3 12" If some one typed 100 it
would look like "P3 100" 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:
"P3 " #
That will show what you want, and the value in the cell will still be a
number.

Hope this helps,
Miguel.
 
Miguel Zapico said:
If you just want it to show on the template, you can use the following custom
format in the cell:
"P3 " #
That will show what you want, and the value in the cell will still be a
number.

Hope this helps,
Miguel.
Click to expand...

OK, great. Then I could have blank cells with that formula in the range and
if I typed "p123 it would come out as "P 123" .............?
 
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 "P3 number"; 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:
"P3 "#;;;"P "@
This will add "P " 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:
="P " & A1
This is the reason why my response started with "if you just want to show",
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.
 
Back
Top