导出excle表中 金额如果小于1000,则不格式化的问题

来源:互联网 发布:卖家怎么找淘宝客推广 编辑:程序博客网 时间:2024/05/13 06:16

style='mso-number-format:"/@"'

 

 

mso-number-format:"0"NO Decimalsmso-number-format:"0/.000"3 Decimalsmso-number-format:"/#/,/#/#0/.000"Comma with 3 decmso-number-format:"mm//dd//yy"Date7mso-number-format:"mmmm/ d/,/ yyyy"Date9mso-number-format:"m//d//yy/ h/:mm/ AM//PM"D -T AMPMmso-number-format:"Short Date"01/03/1998mso-number-format:"Medium Date"01-mar-98mso-number-format:"d/-mmm/-yyyy"01-mar-1998mso-number-format:"Short Time"5:16mso-number-format:"Medium Time"5:16 ammso-number-format:"Long Time"5:16:21:00mso-number-format:"Percent"Percent - two decimalsmso-number-format:"0%"Percent - no decimalsmso-number-format:"0/.E+00"Scientific Notationmso-number-format:"/@"Textmso-number-format:"/#/ ???//???"Fractions - up to 3 digits (312/943)mso-number-format:"/0022£/0022/#/,/#/#0/.00"£12.76mso-number-format:"/#/,/#/#0/.00_ /;/[Red/]/-/#/,/#/#0/.00/ "

2 decimals, negative numbers in red and signed
(1.56   -1.56)

原创粉丝点击