That's O.K. We can solve this.

In A1 thru A3 I entered:

R1
R12
R152


I put my formula in B1 thru B3 and see:

R1 R001
R12 R012
R152 R152

What do you see?


--
Gary''s Student - gsnu200744


"ENFGDC4S" wrote:

I could not get this to work.

"Gary''s Student" wrote:

=LEFT(A1,1) & TEXT(RIGHT(A1,LEN(A1)-1),"000")

--
Gary''s Student - gsnu200744