http://hi.baidu.com/hyqcw/blog/item/bc859718c55e15b94aedbcab.html 将这个公式稍微改一下,就能生成完整的条码了: =B24*10+RIGHT(SUM(LEFT($B24,{0,1}+{1;3;5;7;9;11})*{9,7}))