比如数据在a1在b1输入=LOOKUP(LEFT(A1,FIND("月",A1,1)-1),{"八","二","九","六","七","三","十","十二","十一","四","五","一"},{8,2,9,6,7,3,10,12,11,4,5,1})&"."&LOOKUP(MID(A1,FIND("月",A1,1)+1,3),{"初八","初二","初九","初六","初七","初三","初十","初四","初五","初一","二十","二十八","二十二","二十九","二十六","二十七","二十三","二十四","二十五","二十一","三十","十八","十二","十九","十六","十七","十三","十四","十五","十一"},{"08","02","09","06","07","03","10","04","05","01","20","28","22","29","26","27","23","24","25","21","30","18","12","19","16","17","13","14","15","11"})选中向下拖就oka列的全部转换。