导出excle表中 金额如果小于1000,则不格式化的问题
style='mso-number-format:"/@"'
mso-number-format:"0" | NO Decimals |
mso-number-format:"0/.000" | 3 Decimals |
mso-number-format:"/#/,/#/#0/.000" | Comma with 3 dec |
mso-number-format:"mm//dd//yy" | Date7 |
mso-number-format:"mmmm/ d/,/ yyyy" | Date9 |
mso-number-format:"m//d//yy/ h/:mm/ AM//PM" | D -T AMPM |
mso-number-format:"Short Date" | 01/03/1998 |
mso-number-format:"Medium Date" | 01-mar-98 |
mso-number-format:"d/-mmm/-yyyy" | 01-mar-1998 |
mso-number-format:"Short Time" | 5:16 |
mso-number-format:"Medium Time" | 5:16 am |
mso-number-format:"Long Time" | 5:16:21:00 |
mso-number-format:"Percent" | Percent - two decimals |
mso-number-format:"0%" | Percent - no decimals |
mso-number-format:"0/.E+00" | Scientific Notation |
mso-number-format:"/@" | Text |
mso-number-format:"/#/ ???//???" | Fractions - up to 3 digits (312/943) |
mso-number-format:"/0022£/0022/#/,/#/#0/.00" | £12.76 |
mso-number-format:"/#/,/#/#0/.00_ /;/[Red/]/-/#/,/#/#0/.00/ " |
2 decimals, negative numbers in red and signed |