{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":64,"n_cols":4,"rows_kept":64,"flags":["formulas_cached_only"]}
[null,"Custom Format","Cell Entry","How it Appears"]
[]
["Using text"]
[null,"#,##0 \"US Dollars\"",1500,{"v":1500,"d":"1,500 US Dollars"}]
[null,"\"Answer: \"General",1500,1500]
[null,"\"The amount is \"#,##0\" dollars\"",1500,{"v":1500,"d":"The amount is 1,500 dollars"}]
[]
["Scaling large numbers"]
[null,"#,##0,",123456789,{"v":123456789,"d":"123,457"}]
[null,"#,##0,",12345678912,{"v":12345678912,"d":"12,345,679"}]
[null,"#,##0,",1234,{"v":1234,"d":"1"}]
["Data Validation"]
[null,"0.00;\"Positive numbers only!\"",123,{"v":123,"d":"123.00"}]
[null,"0.00;\"Positive numbers only!\"",-123,-123]
[null,"0.00;\"Positive numbers only!\"",0,{"v":0,"d":"0.00"}]
[]
["Zero with Dashes"]
[null,"#,##0_);(#,##0);-0-_)",0,{"v":0,"d":"-0-"}]
[null,"#,##0_);(#,##0);-0-_)",12.2,{"v":12.2,"d":"12"}]
[null,"#,##0_);(#,##0);-0-_)",-12,{"v":-12,"d":"(12)"}]
[]
["Telephone Numbers"]
[null,"(###) ###-###",8005551212,{"v":8005551212,"d":"(800) 555-1212"}]
[null,"###\"/\"###-####",8005551212,{"v":8005551212,"d":"800/555-1212"}]
[]
["Social Security Numbers"]
[null,"###-##-####",421897322,{"v":421897322,"d":"421-89-7322"}]
[null,"SSN ###-##-####",421897322,{"v":421897322,"d":"SSN 421-89-7322"}]
[]
["Date Formats"]
[null,"mmmm-yy","1995-06-01","1995-06-01"]
[null,"mmmm d, yyyy","1995-06-01","1995-06-01"]
[null,"dddd","1995-06-01","1995-06-01"]
[null,"mmmm d, yyyy (dddd)","1995-06-01","1995-06-01"]
[null,"\"It's\" dddd","1995-06-01","1995-06-01"]
[]
["Different colors and formatting"]
[null,"[Red][<1]0.0%;[Blue][>=1]#,##0;General",1,1]
[null,"[Red][<1]0.0%;[Blue][>=1]#,##0;General",-1,-1]
[null,"[Red][<1]0.0%;[Blue][>=1]#,##0;General",45,45]
[]
[null,"General;General;General;[Red]General","Only text is red","Only text is red"]
[null,"General;General;General;[Red]General",234,234]
[]
["Special symbols"]
[null,"©General",1994,1994]
[null,"General;General;General;General®","Registered","Registered"]
[null,"General;General;General;General™","Coca-Cola","Coca-Cola"]
[null,"General;General;General;“General”","Text in quotes","Text in quotes"]
[null,"General;General;General;“General”",123,123]
[]
["Descriptive","Positive;\"Negative\";\"Zero\";\"Text\"",12,12]
[null,"Positive;\"Negative\";\"Zero\";\"Text\"",-32,-32]
[null,"Positive;\"Negative\";\"Zero\";\"Text\"",0,0]
[null,"Positive;\"Negative\";\"Zero\";\"Text\"","Hello","Hello"]
[]
["Hidden",";;;",1234,1234]
[null,";;;",-145,-145]
[]
["Conditional",null,null,99]
[null,"[>100]#,000;;;",99,99]
[null,"[>100]#,000;;;",102,102]
[null,"[>100]#,000;;;",-54,-54]
[null,"[>100]#,000;;;","Hello","Hello"]