允许包含重复数字可以做。=CONCATENATE(ROUND(RAND()*9,0),ROUND(RAND()*9,0),ROUND(RAND()*9,0),ROUND(RAND()*9,0),ROUND(RAND()*9,0))
你这个基本只能通过vba来实现
