"Miguel Zapico" wrote:

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.

"Big Abalone" wrote:

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?

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" .............?