Excel數(shù)據(jù)庫學(xué)習(xí)5.3.2 自定義數(shù)字格式資料

代碼符號,符號的含義和作用,通過示例來理解,,

,,自定義格式代碼,原始數(shù)值,自定義格式后顯示值

G/通用格式,"按原始輸入顯示,不設(shè)置任何格式,同""常規(guī)""格式",G/通用格式,10.001,10.001

#,數(shù)字占位符，只顯示有效數(shù)字，不顯示無意義的零值.（如果小數(shù)點后數(shù)字位數(shù)大于“#”的數(shù)量，按照“#”的位數(shù)四舍五入）,###,12,12

,,.#,12.65,12.7

0,"數(shù)字占位符，當數(shù)字比代碼的數(shù)量少時，顯示無意義的0.

可以利用代碼0來讓數(shù)值顯示前導(dǎo)零，并讓數(shù)值固定按指定位數(shù)顯示。使用#與0組合為最常用的帶小數(shù)的數(shù)字格式.",0000.00,5678,5678.00

,,,5.678,0005.68

,,#0.0,123456,123456.0

,,,123.546,123.5

?,數(shù)字占位符，需要的時候在小數(shù)點兩側(cè)增加空格；也可以用于具有不同位數(shù)的分數(shù),????.????,1234.1234,1234.1234

,,,-123.123,-123.123

,,,0,.

.,小數(shù)點,,,

",",千位分隔符,"###,###.00",10000,"10,000.00"

,,"0,",10000,10

%,以百分數(shù)顯示,0.00%,56,5600.00%

,,,0.567,56.70%

*,重復(fù)下一個字符來填充列寬,"**#,##0;**-#,##0",1234,"1,234"

,,,-1234,"-1,234"

,,,0,0

_(下劃線),"留出與下一個字符等寬的空格(利用這種格式可以實現(xiàn)""對齊"")",0.00_);(0.00),-0.51,(0.51)

,,,1.25,1.25

,,,-0.78,(0.78)

,,"_(""RMB""*#,##0_);(""RMB""*#,##0)",1234,"RMB1,234"

,,,-123456,"(RMB123,456)"

,,,0,RMB0

！,"強制顯示下一個文本字符,可用于分號(;)點號(.)問號(?)等特殊符號的顯示.","#!""",100,"100"""

,,"#!""!""",100,"100"""""

@,"文本占位符，如果只使用單個@，作用是引用原始文本,如果使用多個@，則可以重復(fù)文本",";;;""集團公司""@""部""",財務(wù),集團公司財務(wù)部

,,,采購,集團公司采購部

,,";;;@""公仆為""@",人民,人民公仆為人民

,,;;;@@@,繼續(xù),繼續(xù)繼續(xù)繼續(xù)

“文本”,顯示雙引號里面的文本,"""MU""0000",5463,MU5463

,,"""USD""#,##0,,""M""",1234567890,"USD1,235M"

,,"""人民幣""#,##0,,""百萬""",1234567890,"人民幣1,235百萬"

[條件值],"設(shè)置條件使用,一般由比較運算符和數(shù)值構(gòu)成",[>99999999](0###)########;########,28758965,28758965

,,,2123459852,(021)23459852

,,,75523459821,(0755)23459821

,,[紅色][>100]0;[藍色]0,99,99

,,,105,105

,,"[綠色][>100]#,##0.00;[紅色][<100]#,##0.00",123.7,123.70

,,,87,87.00

[DBnum1],轉(zhuǎn)換數(shù)值為中文小寫數(shù)字,[DBNum1],123,123

[DBnum2],轉(zhuǎn)換數(shù)值為中文大寫數(shù)字,[DBNum2],123,123