{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Basic Number Formats","Conditional Number Formats"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Basic Number Formats","index":0,"n_rows":97,"n_cols":4,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["Sample Custom Number Formats"]
["Format Code","Description","Data with General Format","Data with Custom Number Format"]
[]
["00000","Always displays 5 digits. Pads with leading",983,983]
[null,"zeros if the number contains fewer than 5 digits.",23589,23589]
[null,"This custom format is very useful when you",9856,9856]
[null,"work with zip codes.",85632,85632]
[]
["0;-0;;@","Suppresses zeros in cells.",98,98]
[null,"This format displays positive values (0) and",0,0]
[null,"negative values (-0), hides zero values, and",-9,-9]
[null,"displays text (@).",0,0]
[null,null,"hello","hello"]
[]
[";;;@","Suppresses numbers in cells.",98,98]
[null,"This format hides positive, negative, and zero",0,0]
[null,"values, and displays only text (@).",-9,-9]
[null,null,0,0]
[null,null,"hello","hello"]
[]
["[Black]General","Suppresses errors in cells.",{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331}]
[null,"This format hides or displays positive,",{"$f":"5/0","v":{"$error":"#DIV/0!"}},{"$f":"5/0","v":{"$error":"#DIV/0!"}}]
["(the cells are also formatted","negative, zero, and text values as black",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
["with a blue font)","characters in the General format. The cells",{"$f":"5/3","v":1.6666666666666667},{"$f":"5/3","v":1.6666666666666667}]
[null,"D21:D25 are formatted with a blue font",{"$f":"4/8","v":0.5},{"$f":"4/8","v":0.5}]
[null,"so that errors do not appear. The other "]
[null,"values appear because the number format"]
[null,"color overrides the font color for the cell."]
[]
["#.???","Lines numbers up with the decimal.",3.2559999999999998,3.2559999999999998]
[null,"The ? code leaves a space for",5.2,5.2]
[null,"insignificant zeros but does not",9.6519999999999992,9.6519999999999992]
[null,"display them.",98.256799999999998,98.256799999999998]
[]
["#,","Displays numbers in thousands.",4058.34,4058.34]
[null,"The comma is the thousands",52865,52865]
[null,"placeholder. If you wish to display",236,236]
[null,"the numbers in millions, use the",5502235623,5502235623]
[null,"format #,, instead.",999555,999555]
[]
["#,###,, \"M\"","Displays numbers in millions.",32654236,32654236]
[null,"The comma is the thousands",4563258963,4563258963]
[null,"placeholder. The letter \"M\" is displayed",1235698516311,1235698516311]
[null,"after each number.",22333666,22333666]
[null,null,12345678,12345678]
[]
["0.00,,","Represents numbers in millions.",1000000,1000000]
[null,"This number format displays numbers",12000000,12000000]
[null,"so that 1 represents one million.",12200000,12200000]
[null,null,120000,120000]
[]
["0;[Red]\"Error!\";0;[Red]\"Error!\"","Displays \"Error!\" in red for negative numbers",10,10]
[null,"and text.","hello","hello"]
[null,"This format may be useful to alert users",-10,-10]
[null,"that they entered invalid text in a cell.",0,0]
[]
["0.0°","Displays numbers with the degree symbol.",32.630000000000003,32.630000000000003]
[null,"The degree symbol uses the character",63.258000000000003,63.258000000000003]
[null,"map code ALT+0176.",96.75,96.75]
[null,null,-5.36,-5.36]
[]
["0.00 £","Displays numbers with the British pounds",100,100]
[null,"symbol.",67.63,67.63]
[null,"The pound symbol uses the character",0,0]
[null,"map code ALT+0163.",9.6300000000000008,9.6300000000000008]
[]
["0.0_-;0.0-","Displays the negative sign on the right side",-5,-5]
[null,"of the number.",-40.299999999999997,-40.299999999999997]
[null,"This format also pads space at the right",50,50]
[null,"of a postive number so that the decimals line up.",-10.99,-10.99]
[]
["     @","Displays 5 spaces and then the text to","this","this"]
[null,"give the appearance of a tab (or indent).","is","is"]
["(5 spaces, then @)",null,"a","a"]
[null,null,"test","test"]
[]
["@*-","Shows text leaders.","Apples","Apples"]
[null,"In a number format, the asterisk (*)","Oranges","Oranges"]
[null,"causes Microsoft Excel to repeat the next","Bananas","Bananas"]
[null,"character until the width of the column","Pears","Pears"]
[null,"is filled. Text leaders are commonly used in","Peaches","Peaches"]
[null,"tables of contents.","Plums","Plums"]
[null,null,"Grapes","Grapes"]
[]
["0 \"dollars and\" .00 \"cents\"","Displays a currency value with words.",20.36,20.36]
[null,"This format displays the whole number",2.5499999999999998,2.5499999999999998]
[null,"portion of the number followed by the",45.36,45.36]
[null,"words \"dollars and,\" followed by the fractional",69,69]
[null,"portion of the number and the word \"cents.\" ",36.25,36.25]
[null,null,1003.33,1003.33]
[]
["0\".\"00","Displays a value in hundreds.",2300,2300]
[null,"The comma is used only for scaling",23,23]
[null,"numbers in multiples of one thousand. Use ",400,400]
[null,"a number format with a decimal character",5000,5000]
[null,"between the placeholders to display a  ",-90,-90]
[null,"number as a multiple of 100 or 10 (0\".\"0).",0,0]

{"sheet":"Conditional Number Formats","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Sample Custom Number Formats"]
["Format Code","Description","Data with General Format","Data with Custom Number Format"]
[]
["[>9999999](000)000-0000;000-0000","Displays a telephone number with or without an",7045556325,7045556325]
[null,"area code.",9106325689,9106325689]
[null,"If the number is greater than 9,999,999, this code",8896523,8896523]
[null,"displays the number with an area code",5362563,5362563]
[null,"((000)000-0000); otherwise the number appears",2065896325,2065896325]
[null,"without the area code (000-0000).",3369856,3369856]
[]
["[<1].00¢;$0.00_¢","Shows currency values in dollars or cents.",1.25,1.25]
[null,"This code displays values less than 1 in",3,3]
[null,"cents notation (.00¢), and display values",0.35,0.35]
[null,"greater than or equal to 1 in dollars, and",0.95,0.95]
[null,"leaves a space on the right so that the",22.36,22.36]
[null,"decimals line up ($0.00_¢).",0.75,0.75]
[]
["[<=2]\"Low\"* 0;[>=4]\"High\"* 0;\"Average\"* 0","Using \"If, ElseIf, Else\" in a number format:",1,1]
[null,"        If the value is <=2, display the word \"low\"",2,2]
[null,"                with the value,",3,3]
[null,"        Else If the value is >=4, display the word",4,4]
[null,"                \"high\" with the value,",5,5]
[null,"        Else display the word \"Average\" with "]
[null,"                value."]
[]
["[Red][<=2]0;[Green][>=4]0;[Black]0","Using \"If, ElseIf, Else\" in a number format:",1,1]
[null,"        If the value is <=2, display the value ",2,2]
[null,"                with red text,",3,3]
[null,"        Else If the value is >=4, display the value",4,4]
[null,"                with green text,",5,5]
[null,"        Else display the value with black text."]