software

Having a problem with formatting leading zeros. I am running a macro
that calculates RAND() and RANK then returns a 2 digit number in Col Y
and another 2 digit in Col Z with whichever 2 digit number is ranked 1
then I do a Sum with this formula =LARGE((Z29:Z84),1) then try to join
both 2 digit numbers with this formula
=LARGE((Y85:Y86),1)amp;LARGE((Z85:Z86),1) my macro calculates and then
copies and pastes results to Col A 25 times but I can not get leading
zeros to show no matter how I try to format col Y or col Z or col A Can
anyone help me with this. It is driving me nuts!!!!!Try either

=--(LARGE(Y85:Y86,1)amp;LARGE(Z85:Z86,1))

and use a custom format of 0000
or if you don't need to do any calculations with the numbers

=TEXT(LARGE(Y85:Y86,1)amp;LARGE(Z85:Z86,1),quot;0000quot;)

you had some extra parenthesis btw

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;bobquot; gt; wrote in message oups.com...
gt; Having a problem with formatting leading zeros. I am running a macro
gt; that calculates RAND() and RANK then returns a 2 digit number in Col Y
gt; and another 2 digit in Col Z with whichever 2 digit number is ranked 1
gt; then I do a Sum with this formula =LARGE((Z29:Z84),1) then try to join
gt; both 2 digit numbers with this formula
gt; =LARGE((Y85:Y86),1)amp;LARGE((Z85:Z86),1) my macro calculates and then
gt; copies and pastes results to Col A 25 times but I can not get leading
gt; zeros to show no matter how I try to format col Y or col Z or col A Can
gt; anyone help me with this. It is driving me nuts!!!!!
gt;thanks works great...