Change the
&TEXT(A3,"00")
to read
&TEXT(A3,"0#")

Regards
Steve

"Nadine" wrote in message
...
Gary,
If the payment # is 10, this formula records it as 01. How do I write the
formula so pmt 1 comes out as 01 and pmt 10 comes out as 10 and pmt 15
comes
out as 15, etc?
Thanks.


"Gary''s Student" wrote:

A tiny trick:

=RIGHT(LEFT(A1,5)&RIGHT(A1,10),12)&A2&TEXT(A3,"00" )
--
Gary''s Student - gsnu201003


"Nadine" wrote:

I have 3 cells I need to merge into one. One of the cells is a number
anywhere from 1-16 or more. What I need is for the number in this
cells to
always be concatenated into a 2 digit number. Example:
Cell A1 = USA123-4555678952
Cell A2 = CD
Cell A3 = 4
I need the final output to be 234555678952CD04.
So far I have the following formula:
=RIGHT(LEFT(A1,5)&RIGHT(A1,10),12)&A2&A3 but this doesn't put "04"
after the
CD. It only puts "4" after it. Any ideas for Excel 2003?
Thanks.