Help with leading Zeros when running Macro
 

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)&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!!!!!

Help with leading Zeros when running Macro
 

Try either

=--(LARGE(Y85:Y86,1)&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)&LARGE(Z85:Z86,1),"0000")

you had some extra parenthesis btw

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"bob" wrote in message
oups.com...
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)&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!!!!!

Help with leading Zeros when running Macro
 

thanks works great...