{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["NOTES","Format Codes","TEXT() function intro","Thousands separator","Number, currency, accounting","Months, days, years","Hours, minutes, seconds","Date & time","Percentage","Fraction","Scientific notation","Special","Symbols","Combine multiple formats","Custom","Leading 0's","New line","Page Header & Footer"],"not_rendered":{"images":6,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"NOTES","index":0,"n_rows":27,"n_cols":3,"rows_kept":27}
[]
[null,"Excel TEXT function Examples"]
[]
[null,"The following worksheets have various TEXT function examples as mentioned in the following Support.Office.com article: "]
[]
[null,"TEXT function reference"]
[]
[null,"Each worksheet is listed below, along with what kind of examples you'll find, and each sheet name is hyperlinked to the sheet."]
[]
[null,"Worksheet","Description"]
[null,"Format Codes","List of the format codes from the Format Cells dialog"]
[null,"TEXT() function intro","TEXT function overview and examples"]
[null,"Thousands separator","Using the Thousands separator with the TEXT function"]
[null,"Number, currency, accounting","Applying number, currency and accounting formats with the TEXT function"]
[null,"Months, days, years","Applying months, days and year formats with the TEXT function"]
[null,"Hours, minutes, seconds","Applying hours, minutes and second formats with the TEXT function"]
[null,"Date & time","Applying date & and time formats with the TEXT function"]
[null,"Percentage","Applying percentage formats with the TEXT function"]
[null,"Fraction","Applying fraction formats with the TEXT function"]
[null,"Scientific notation ","Applying Scientific notation formats with the TEXT function"]
[null,"Special","Applying Special formats with the TEXT function"]
[null,"Symbols","Using symbols and custom formats with the TEXT function"]
[null,"Combine multiple formats","Combining multiple text and value formats with the TEXT function"]
[null,"Custom","Creating and applying Custom formats with the TEXT function"]
[null,"Leading 0's","Applying leading 0's with the TEXT function and convert text to numbers "]
[null,"New line","Applying new lines with CHAR(10) and the TEXT function"]
[null,"Page Header & Footer","Adding dates and times to a Page Header or Footer"]

{"sheet":"Format Codes","index":1,"n_rows":18,"n_cols":9,"rows_kept":18}
["Excel Format Codes from the Format Cells dialog"]
[]
["Format Code","Description","Example",{"$nulls":5},"• Use Ctrl+1 to launch the Format Cells dialog"]
["General","No specific number format",1234.56]
["Number","General number display with or without thousand separators and decimals",{"v":1234.56,"d":"1,234.56"}]
["Currency","Currency formats are used for general monetary values",{"v":1234.56,"d":"$1,234.56"}]
["Accounting","Accounting formats line up the currency symbols and decimal points in a column",{"v":1234.56,"d":"$1,234.56"}]
["Date","Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operating system. Formats without an asterisk are not affected by operating system settings.",{"$f":"TODAY()","v":"2016-10-27"}]
["Time","Time formats display date and time serial numbers as date values. Time formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specific for the operating system. Formats without an asterisk are not affected by operating system settings.",{"$f":"NOW()","v":42670.6996037037}]
["Percentage","Percentage formats multiply the cell value by 100 and displays the results with a percent symbol (%).",{"v":0.123,"d":"12.30%"}]
["Fraction","Fraction formats display numbers as fractions rather than decimals.",1.75]
["Scientific","The Scientific format displays a number in exponential notation, replacing part of the number with E+ n, where E (which stands for Exponent) multiplies the preceding number by 10 to the n th power. For example, a 2-decimal Scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power.",{"v":123456789,"d":"1.23E+08"}]
["Text","Text format cells are treated as text even when a number is in the cell.\nThe cell is displayed exactly as entered.",1234]
["Special","Special formats are useful for tracking list and database values. The following special formats are included:\n• Zip Code\n• Zip Code + 4\n• Phone Number\n• Social Security Number",{"$f":"\"12345\"&CHAR(10)&TEXT(123451234,\"00000-0000\")&CHAR(10)&TEXT(1234567899,\"[<=9999999]###-####;(###) ###-####\")&CHAR(10)&TEXT(123456789,\"###-##-####\")","v":"12345\n12345-1234\n(123) 456-7899\n123-45-6789"}]
["Custom","Create your own format code, using one of the existing codes as a starting point","N/A"]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"TEXT() function intro","index":2,"n_rows":26,"n_cols":4,"rows_kept":26}
["TEXT function"]
[]
["• The TEXT function lets you convert a number into a text string."]
[]
["• =TEXT(Value you want to format, “Format you want to apply\")"]
[]
["Basic examples"]
["Value","Formula","Result"]
[{"$f":"TODAY()","v":"2016-10-27"},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=TEXT(A9,\"MM/DD/YY\")"},{"$f":"TEXT(A9,\"MM/DD/YY\")","v":"10/27/16"}]
[{"$f":"TODAY()","v":"2016-10-27"},{"$f":"_xlfn.FORMULATEXT(C10)","v":"=TEXT(A10,\"DDDD\")"},{"$f":"TEXT(A10,\"DDDD\")","v":"Thursday"}]
[0.285,{"$f":"_xlfn.FORMULATEXT(C11)","v":"=TEXT(A11,\"0.00%\")"},{"$f":"TEXT(A11,\"0.00%\")","v":"28.50%"}]
[]
["Combining text and numbers without the TEXT function"]
["Text to combine","Value","Formula","Result"]
["Report Printed on:","2012-03-14",{"$f":"_xlfn.FORMULATEXT(D15)","v":"=A15&\" \"&B15"},{"$f":"A15&\" \"&B15","v":"Report Printed on: 40982"}]
["Package Delivered at:","15:30:00",{"$f":"_xlfn.FORMULATEXT(D16)","v":"=A16&\" \"&B16"},{"$f":"A16&\" \"&B16","v":"Package Delivered at: 0.645833333333333"}]
["Weekly Revenue:",{"v":66348.72,"d":"$66,348.72"},{"$f":"_xlfn.FORMULATEXT(D17)","v":"=A17&\" \"&B17"},{"$f":"A17&\" \"&B17","v":"Weekly Revenue: 66348.72"}]
[]
["Combining text and numbers with the TEXT function"]
["Text to combine","Value","Formula","Result"]
["Report Printed on:","2012-03-14",{"$f":"_xlfn.FORMULATEXT(D21)","v":"=A21&\" \"&TEXT(B21,\"mm/dd/yy\")"},{"$f":"A21&\" \"&TEXT(B21,\"mm/dd/yy\")","v":"Report Printed on: 03/14/12"}]
["Package Delivered at:","15:30:00",{"$f":"_xlfn.FORMULATEXT(D22)","v":"=A22&\" \"&TEXT(B22,\"HH:MM AM/PM\")"},{"$f":"A22&\" \"&TEXT(B22,\"HH:MM AM/PM\")","v":"Package Delivered at: 03:30 PM"}]
["Weekly Revenue:",{"v":66348.72,"d":"$66,348.72"},{"$f":"_xlfn.FORMULATEXT(D23)","v":"=A23&\" \"&TEXT(B23,\"$#,###.##\")"},{"$f":"A23&\" \"&TEXT(B23,\"$#,###.##\")","v":"Weekly Revenue: $66,348.72"}]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Thousands separator","index":3,"n_rows":11,"n_cols":3,"rows_kept":11}
["Thousands separator"]
[]
["Value","Formula","Result"]
[12200000,{"$f":"_xlfn.FORMULATEXT(C4)","v":"=TEXT(A4,\"#,###\")"},{"$f":"TEXT(A4,\"#,###\")","v":"12,200,000"}]
[12200000,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(A5,\"0,000.00\")"},{"$f":"TEXT(A5,\"0,000.00\")","v":"12,200,000.00"}]
[12200000,{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(A6,\"#,\")"},{"$f":"TEXT(A6,\"#,\")","v":"12200"}]
[12200000,{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(A7,\"#,###.0,\")"},{"$f":"TEXT(A7,\"#,###.0,\")","v":"12,200.0"}]
[12200000,{"$f":"_xlfn.FORMULATEXT(C8)","v":"=TEXT(A8,\"0.0,,\")"},{"$f":"TEXT(A8,\"0.0,,\")","v":"12.2"}]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Number, currency, accounting","index":4,"n_rows":17,"n_cols":13,"rows_kept":17}
["Number, Currency and Accounting formats"]
[{"$nulls":12},"• Currency symbol selection"]
["Value","Description","Formula","Result"]
[1234.56,"Number - General",{"$f":"_xlfn.FORMULATEXT(D4)","v":"=TEXT(A4,\"0.00\")"},{"$f":"TEXT(A4,\"0.00\")","v":"1234.56"}]
[1234.56,"Number - thousands separator, \nno decimals","=TEXT(A5,\"#,##0\")",{"$f":"TEXT(A5,\"#,##0\")","v":"1,235"}]
[1234.56,"Number - thousands separator, \n2 decimals","=TEXT(A6,\"#,##0.00\")",{"$f":"TEXT(A6,\"#,##0.00\")","v":"1,234.56"}]
[1234.56,"Currency - no decimals","=TEXT(A7,\"$#,##0\")",{"$f":"TEXT(A7,\"$#,##0\")","v":"$1,235"}]
[1234.56,"Currency - 2 decimals","=TEXT(A8,\"$#,##0.00\")",{"$f":"TEXT(A8,\"$#,##0.00\")","v":"$1,234.56"}]
[-1234.56,"Currency - 2 decimals, \nnegative value","=TEXT(A9,\"$#,##0.00_);($#,##0.00)\")",{"$f":"TEXT(A9,\"$#,##0.00_);($#,##0.00)\")","v":"($1,234.56)"}]
[1234.56,"Accounting - no decimals","=TEXT(A10,\"$ * #,##0\")",{"$f":"TEXT(A10,\"$ * #,##0\")","v":"$ 1,235"}]
[1234.56,"Accounting - 2 decimals","=TEXT(A11,\"$ * #,##0.00\")",{"$f":"TEXT(A11,\"$ * #,##0.00\")","v":"$ 1,234.56"}]
[]
["Cell formatting with negative value in red - the TEXT function doesn't support color formatting"]
[{"v":-1234.56,"d":"($1,235)"},"Currency with a negative value formated as $#,##0._);[Red]($#,##0.) from the Format Cells dialog"]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Months, days, years","index":5,"n_rows":25,"n_cols":5,"rows_kept":25}
["Date Formats - Months, days and years"]
[]
["Date:",{"$f":"TODAY()","v":"2016-10-27"}]
[]
["To display","As","Format","Formula","Result"]
["Months","1–12","\"m\"",{"$f":"_xlfn.FORMULATEXT(E6)","v":"=TEXT(B3,\"m\")"},{"$f":"TEXT(B3,\"m\")","v":"10"}]
["Months","01–12","\"mm\"",{"$f":"_xlfn.FORMULATEXT(E7)","v":"=TEXT(B3,\"mm\")"},{"$f":"TEXT(B3,\"mm\")","v":"10"}]
["Months","Jan–Dec","\"mmm\"","=TEXT(B3,\"mmm\")",{"$f":"TEXT(B3,\"mmm\")","v":"Oct"}]
["Months","January–December","\"mmmm\"","=TEXT(B3,\"mmmm\")",{"$f":"TEXT(B3,\"mmmm\")","v":"October"}]
["Months","J–D","\"mmmmm\"","=TEXT(B3,\"mmmmm\")",{"$f":"TEXT(B3,\"mmmmm\")","v":"O"}]
["Days","1–31","\"d\"","=TEXT(B3,\"d\")",{"$f":"TEXT(B3,\"d\")","v":"27"}]
["Days","01–31","\"dd\"","=TEXT(B3,\"dd\")",{"$f":"TEXT(B3,\"dd\")","v":"27"}]
["Days","Sun–Sat","\"ddd\"","=TEXT(B3,\"ddd\")",{"$f":"TEXT(B3,\"ddd\")","v":"Thu"}]
["Days","Sunday–Saturday","\"dddd\"","=TEXT(B3,\"dddd\")",{"$f":"TEXT(B3,\"dddd\")","v":"Thursday"}]
["Years","00–99","\"yy\"","=TEXT(B3,\"yy\")",{"$f":"TEXT(B3,\"yy\")","v":"16"}]
["Years","1900–9999","\"yyyy\"","=TEXT(B3,\"yyyy\")",{"$f":"TEXT(B3,\"yyyy\")","v":"2016"}]
[]
["You could also use a Named Range instead of a cell value, where cell B3 has been named \"StartDate\"."]
[]
[null,"Formula","Result"]
[null,{"$f":"_xlfn.FORMULATEXT(C21)","v":"=TEXT(StartDate,\"m\")"},{"$f":"TEXT(StartDate,\"m\")","v":"10"}]
[]
["See more: Define and use names in formulas"]
[]
["See more online: TEXT function reference"]

{"sheet":"Hours, minutes, seconds","index":6,"n_rows":21,"n_cols":5,"rows_kept":21}
["Time formats - Hours, minutes and seconds"]
[]
["Current time:",{"$f":"NOW()","v":42670.6996037037}]
[]
["To display","As","Format","Formula","Result"]
["Hours","0-23","\"h\"",{"$f":"_xlfn.FORMULATEXT(E6)","v":"=TEXT(B3,\"h\")"},{"$f":"TEXT(B3,\"h\")","v":"16"}]
["Hours","00-23","\"hh\"",{"$f":"_xlfn.FORMULATEXT(E7)","v":"=TEXT(B3,\"hh\")"},{"$f":"TEXT(B3,\"hh\")","v":"16"}]
["Minutes","0-59","\"m\"","=TEXT(B3,\"m\")",{"$f":"TEXT(B3,\"m\")","v":"10"}]
["Minutes","00-59","\"mm\"","=TEXT(B3,\"mm\")",{"$f":"TEXT(B3,\"mm\")","v":"10"}]
["Seconds","0-59","\"s\"","=TEXT(B3,\"s\")",{"$f":"TEXT(B3,\"s\")","v":"26"}]
["Seconds","00-59","\"ss\"","=TEXT(B3,\"ss\")",{"$f":"TEXT(B3,\"ss\")","v":"26"}]
["Time",{"$f":"StartTime","v":42670.6996037037},"\"h AM/PM\"","=TEXT(B3,\"h AM/PM\")",{"$f":"TEXT(B3,\"h AM/PM\")","v":"4 PM"}]
["Time",{"$f":"StartTime","v":42670.6996037037},"\"h:mm AM/PM\"","=TEXT(B3,\"h:mm AM/PM\")",{"$f":"TEXT(B3,\"h:mm AM/PM\")","v":"4:47 PM"}]
["Time",{"$f":"StartTime","v":42670.6996037037},"\"h:mm:ss A/P\"","=TEXT(B3,\"h:mm:ss A/P\")",{"$f":"TEXT(B3,\"h:mm:ss A/P\")","v":"4:47:26 P"}]
["Time",{"$f":"StartTime","v":42670.6996037037},"\"h:mm:ss.00\"","=TEXT(B3,\"h:mm:ss.00\")",{"$f":"TEXT(B3,\"h:mm:ss.00\")","v":"16:47:25.76"}]
["Elapsed Time \n(hours & minutes)",0.04305555555555556,"\"[h]:mm\"","=TEXT(B16,\"[h]:mm\")",{"$f":"TEXT(B16,\"[h]:mm\")","v":"1:02"}]
["Elapsed Time \n(minutes & seconds)",0.04324074074074074,"\"[mm]:ss\"","=TEXT(B17,\"[mm]:ss\")",{"$f":"TEXT(B17,\"[mm]:ss\")","v":"62:16"}]
["Elapsed Time \n(seconds & hundredths)",0.04323842592592592,"\"[ss].00\"","=TEXT(B18,\"[ss].00\")",{"$f":"TEXT(B18,\"[ss].00\")","v":"3735.80"}]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Date & time","index":7,"n_rows":20,"n_cols":2,"rows_kept":20}
["Combine Date & Time formats"]
[]
["Current Date/Time:",{"$f":"NOW()","v":"2016-10-27T16:47:25.760"}]
[]
["Formula","Result"]
[{"$f":"_xlfn.FORMULATEXT(B6)","v":"=\"Date: \"&TEXT(B3,\"mm/dd/yyyy\")"},{"$f":"\"Date: \"&TEXT(B3,\"mm/dd/yyyy\")","v":"Date: 10/27/2016"}]
[{"$f":"_xlfn.FORMULATEXT(B7)","v":"=\"Date-time: \" & TEXT(B3, \"m/d/yyyy h:mm AM/PM\")"},{"$f":"\"Date-time: \" & TEXT(B3, \"m/d/yyyy h:mm AM/PM\")","v":"Date-time: 10/27/2016 4:47 PM"}]
[]
[]
["Full sentence"]
[{"$f":"\"Today is \"&TEXT(B3,\"dddd, mmmm yyyy\")&\", and the current time is \"&TEXT(B3,\"hh/mm AM/PM\")&\".\"","v":"Today is Thursday, October 2016, and the current time is 04/47 PM."}]
[]
[{"$f":"_xlfn.FORMULATEXT(A11)","v":"=\"Today is \"&TEXT(B3,\"dddd, mmmm yyyy\")&\", and the current time is \"&TEXT(B3,\"hh/mm AM/PM\")&\".\""}]
[]
[]
[]
[]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Percentage","index":8,"n_rows":16,"n_cols":4,"rows_kept":16}
["Percentage formats"]
[]
["Value","Description","Formula","Result"]
[0.2447400883929619,"No decimals",{"$f":"_xlfn.FORMULATEXT(D4)","v":"=TEXT(A4,\"0%\")"},{"$f":"TEXT(A4,\"0%\")","v":"24%"}]
[0.2447400883929619,"1 decimal","=TEXT(A5,\"0.0%\")",{"$f":"TEXT(A5,\"0.0%\")","v":"24.5%"}]
[0.2447400883929619,"2 decimals","=TEXT(A6,\"0.00%\")",{"$f":"TEXT(A6,\"0.00%\")","v":"24.47%"}]
{"$rows_empty":9}
["See more online: TEXT function reference"]

{"sheet":"Fraction","index":9,"n_rows":22,"n_cols":4,"rows_kept":22}
["Fraction formats"]
[]
["Value","Description","Formula","Result"]
[4.34,"Up to one digit (1/4)",{"$f":"_xlfn.FORMULATEXT(D4)","v":"=TEXT(A4,\"# ?/?\")"},{"$f":"TEXT(A4,\"# ?/?\")","v":"4 1/3"}]
[0.34,"Up to one digit (1/4) **","=TRIM(TEXT(A5,\"# ?/?\"))",{"$f":"TRIM(TEXT(A5,\"# ?/?\"))","v":"1/3"}]
[4.34,"Up to two digits (21/25)","=TEXT(A6,\"# ??/??\")",{"$f":"TEXT(A6,\"# ??/??\")","v":"4 17/50"}]
[4.34,"Up to three digits (312/943)","=TEXT(A7,\"# ???/???\")",{"$f":"TEXT(A7,\"# ???/???\")","v":"4  17/50 "}]
[4.34,"As halves (1/2)","=TEXT(A8,\"# ?/2\")",{"$f":"TEXT(A8,\"# ?/2\")","v":"4 1/2"}]
[4.34,"As quarters (2/4)","=TEXT(A9,\"# ?/4\")",{"$f":"TEXT(A9,\"# ?/4\")","v":"4 1/4"}]
[4.34,"As sixteenths (8/16)","=TEXT(A10,\"# ??/16\")",{"$f":"TEXT(A10,\"# ??/16\")","v":"4  5/16"}]
[4.34,"As tenths (3/10)","=TEXT(A11,\"# ?/10\")",{"$f":"TEXT(A11,\"# ?/10\")","v":"4 3/10"}]
[4.34,"As hundreths (30/100)","=TEXT(A12,\"# ??/100\")",{"$f":"TEXT(A12,\"# ??/100\")","v":"4 34/100"}]
{"$rows_empty":9}
["See more online: TEXT function reference"]

{"sheet":"Scientific notation","index":10,"n_rows":15,"n_cols":4,"rows_kept":15}
["Scientific notation formats"]
[]
["Value","Description","Formula","Result"]
[{"v":12200000,"d":"12,200,000"},"Scientific - 7 places",{"$f":"_xlfn.FORMULATEXT(D4)","v":"=TEXT(A4,\"0.00E+00\")"},{"$f":"TEXT(A4,\"0.00E+00\")","v":"1.22E+07"}]
[{"v":12200000,"d":"12,200,000"},"Scientific - 6 places",{"$f":"_xlfn.FORMULATEXT(D5)","v":"=TEXT(A5,\"#0.0E+0\")"},{"$f":"TEXT(A5,\"#0.0E+0\")","v":"12.2E+6"}]
{"$rows_empty":9}
["See more online: TEXT function reference"]

{"sheet":"Special","index":11,"n_rows":10,"n_cols":4,"rows_kept":10}
["Special formats - Zip code, Zip +4, Phone number, Social Security number"]
[]
["Value","Description","Formula","Result"]
[12345,"Zip Code",{"$f":"_xlfn.FORMULATEXT(D4)","v":"=TEXT(A4,\"00000\")"},{"$f":"TEXT(A4,\"00000\")","v":"12345"}]
[123456789,"Zip Code + 4",{"$f":"_xlfn.FORMULATEXT(D5)","v":"=TEXT(A5,\"00000-0000\")"},{"$f":"TEXT(A5,\"00000-0000\")","v":"12345-6789"}]
[1234567899,"Phone Number",{"$f":"_xlfn.FORMULATEXT(D6)","v":"=TEXT(A6,\"[<=9999999]###-####;(###) ###-####\")"},{"$f":"TEXT(A6,\"[<=9999999]###-####;(###) ###-####\")","v":"(123) 456-7899"}]
[123456789,"Social Security Number",{"$f":"_xlfn.FORMULATEXT(D7)","v":"=TEXT(A7,\"000-00-0000\")"},{"$f":"TEXT(A7,\"000-00-0000\")","v":"123-45-6789"}]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Symbols","index":12,"n_rows":26,"n_cols":5,"rows_kept":26}
["Using Symbols with the TEXT function to create custom formats"]
[]
["Symbol","Name",null,"To enter","Use this key combination"]
["$","Dollar sign",null,"¢","ALT+0162"]
["+","Plus sign",null,"£","ALT+0163"]
["(","Left parenthesis",null,"¥","ALT+0165"]
[":","Colon",null,"€","ALT+0128"]
["^","Circumflex accent (caret)"]
["'","Apostrophe"]
["{","Left curly bracket"]
["<","Less-than sign"]
["=","Equal sign"]
["-","Minus sign"]
["/","Slash mark"]
[")","Right parenthesis"]
["!","Exclamation point"]
["&","Ampersand"]
["~","Tilde"]
["}","Right curly bracket"]
[">","Greater-than sign"]
[null,"Space character"]
[]
[]
["See more: Create or delete a custom number format"]
[]
["See more online: TEXT function reference"]

{"sheet":"Combine multiple formats","index":13,"n_rows":13,"n_cols":6,"rows_kept":13}
["Create sentences with the TEXT function"]
[{"$nulls":3},"Details"]
["Formula","Result",null,"Salesperson","Sales","% of Total"]
[{"$f":"_xlfn.FORMULATEXT(B4)","v":"=D4&\" sold \"&TEXT(E4,\"$#,###\")&\" worth of units.\""},{"$f":"D4&\" sold \"&TEXT(E4,\"$#,###\")&\" worth of units.\"","v":"Robbie Burke sold $2,800 worth of units."},null,"Robbie Burke",{"v":2800,"d":"$2,800.00"},{"v":0.4,"d":"40%"}]
[{"$f":"_xlfn.FORMULATEXT(B5)","v":"=D4&\" had \"&TEXT(F4, \"0%\")&\" of total sales.\""},{"$f":"D4&\" had \"&TEXT(F4, \"0%\")&\" of total sales.\"","v":"Robbie Burke had 40% of total sales."}]
{"$rows_empty":7}
["See more online: TEXT function reference"]

{"sheet":"Custom","index":14,"n_rows":8,"n_cols":4,"rows_kept":8}
["Custom formats"]
[]
["Value","Description","Formula","Result"]
["123456","ID # & 9-Digit number",{"$f":"_xlfn.FORMULATEXT(D4)","v":"=\"ID# \"&TEXT(A4,\"000000000\")"},{"$f":"\"ID# \"&TEXT(A4,\"000000000\")","v":"ID# 000123456"}]
[123456,"Latitude/Longitude",{"$f":"_xlfn.FORMULATEXT(D5)","v":"=TEXT(A5,\"###° 00' 00''\")"},{"$f":"TEXT(A5,\"###° 00' 00''\")","v":"12° 34' 56''"}]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"Leading 0's","index":15,"n_rows":11,"n_cols":5,"rows_kept":11}
["Restore leading 0's and convert back to numbers"]
[]
[null,"Original Value","Leading 0's removed","TEXT function ","Convert back to Numbers"]
[null,"00001",1,{"$f":"TEXT(B4,\"00000\")","v":"00001"},{"$f":"--D4","v":1}]
[null,"00012",12,{"$f":"TEXT(B5,\"00000\")","v":"00012"},{"$f":"--D5","v":12}]
[null,"00123",123,{"$f":"TEXT(B6,\"00000\")","v":"00123"},{"$f":"--D6","v":123}]
[null,"01234",1234,{"$f":"TEXT(B7,\"00000\")","v":"01234"},{"$f":"--D7","v":1234}]
[null,"12345",12345,{"$f":"TEXT(B8,\"00000\")","v":"12345"},{"$f":"--D8","v":12345}]
[]
[]
["See more online: TEXT function reference"]

{"sheet":"New line","index":16,"n_rows":12,"n_cols":2,"rows_kept":12}
["Use CHAR(10) with the TEXT function to add a new line"]
[]
["Formula","TEXT w/a \nLine Break"]
[{"$f":"_xlfn.FORMULATEXT('New line'!$B$4:$B$4)","v":"=\"Today is: \"&CHAR(10)&TEXT(TODAY(),\"mm/dd/yy\")"},{"$f":"\"Today is: \"&CHAR(10)&TEXT(TODAY(),\"mm/dd/yy\")","v":"Today is: \n10/27/16"}]
{"$rows_empty":7}
["See more online: TEXT function reference"]

{"sheet":"Page Header & Footer","index":17,"n_rows":45,"n_cols":11,"rows_kept":45}
["Add a Date/Time Stamp to a Page Header/Footer"]
{"$rows_empty":12}
["1.","Choose the Page Setup flyout in the Page Layout ribbon tab"]
[]
[]
[]
[]
[]
[]
["2.","Click the Header/Footer tab on the Page Setup dialog",{"$nulls":7},"3.","Add your section text and click on the Date or Time buttons above"]
{"$rows_empty":23}
["See more online: TEXT function reference"]