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