Either leave it as text, or format the cell as 0000
--
David Biddulph

"vcff" wrote in message
...
sorry I make a mistake on the wording "value" and had got it right.
However if my cell Ai is P0012 (double zero), it will only show as 12.
How can I keep the zero's?
tnks and b r


" wrote:

"vcff" wrote:
I need to remove the letter at the beginning of each part number.

=right(A1,len(A1)-1)

That results in text. If you want a number, then:

=value(right(...))