Is there anyway to create VBA that will tell Excel that 528 > 670 ? I want contracts numbered 528X-1111 and 528X-1112 to be listed before contracts numbered 670-1110 and 670-1109 but it doesn't want to when I sort by descending number. Is there a way to fool Excel into thinking that 528 is greater? Thanks