{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["TEXT Function","Format Numbers","Combine Text and Dates","Combine Text and Numbers","Leading Zeros","Phone Number","Change font","Bold italic & underline","Change font size","Change font color","format part of cell","VBA FORMAT Function","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"TEXT Function","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Date Format Using TEXT Function"]
[]
[null,"Date","Format"]
[null,"2023-10-10",{"$f":"TEXT(B5,\"DD MMM,YYYY\")","v":"10 Oct,2023"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(B5,\"DD MMM,YYYY\")"}]
[null,"2023-10-11",{"$f":"TEXT(B6,\"DD MMMM,YYYY\")","v":"11 October,2023"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(B6,\"DD MMMM,YYYY\")"}]
[null,"2023-10-12",{"$f":"TEXT(B7,\"DD-MMM-YYYY\")","v":"12-Oct-2023"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(B7,\"DD-MMM-YYYY\")"}]
[null,"2023-10-13",{"$f":"TEXT(B8,\"YYYY,MMM DD\")","v":"2023,Oct 13"},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=TEXT(B8,\"YYYY,MMM DD\")"}]
[null,"2023-10-14",{"$f":"TEXT(B9,\"YYYY,MMMM DD\")","v":"2023,October 14"},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=TEXT(B9,\"YYYY,MMMM DD\")"}]

{"sheet":"Format Numbers","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Number Format Using TEXT Function"]
[]
[null,"Numbers","Format"]
[null,2545,{"$f":"TEXT(B5,\"$###,###.00\")","v":"$2,545.00"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(B5,\"$###,###.00\")"}]
[null,1.5,{"$f":"TEXT(B6,\"#%\")","v":"150%"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(B6,\"#%\")"}]
[null,2653,{"$f":"TEXT(B7,\"+ $#,##0.00;- $#,##0.00;$0.00\")","v":"+ $2,653.00"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(B7,\"+ $#,##0.00;- $#,##0.00;$0.00\")"}]
[null,4582.5,{"$f":"TEXT(B8, \"- $#,##0.00;- $#,##0.00;$0.00\")","v":"- $4,582.50"},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=TEXT(B8, \"- $#,##0.00;- $#,##0.00;$0.00\")"}]
[null,4582.5,{"$f":"TEXT(B9,\"# ?/?\")","v":"4582 1/2"},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=TEXT(B9,\"# ?/?\")"}]

{"sheet":"Combine Text and Dates","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,4,8,8],[1,1,1,3]]}
[]
[null,"Combine TEXT and Date in Desired Format"]
[]
[null,"Text","Date","Combined Format"]
[null,"Today is","2023-06-21",{"$f":"CONCATENATE(B5,\" \",TEXT(C5,\"DD MMM,YYYY\"))","v":"Today is 21 Jun,2023"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=CONCATENATE(B5,\" \",TEXT(C5,\"DD MMM,YYYY\"))"}]
[null,"Today is","2023-06-21",{"$f":"CONCATENATE(B6,\" \",TEXT(C6,\"DDDD DD MMM,YYYY\"))","v":"Today is Wednesday 21 Jun,2023"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=CONCATENATE(B6,\" \",TEXT(C6,\"DDDD DD MMM,YYYY\"))"}]
[null,"The Delivery is due at ","2023-10-12",{"$f":"CONCATENATE(B7,\" \",TEXT(C7,\"DD-MMM-YYYY\"))","v":"The Delivery is due at  12-Oct-2023"},{"$f":"_xlfn.FORMULATEXT(D7)","v":"=CONCATENATE(B7,\" \",TEXT(C7,\"DD-MMM-YYYY\"))"}]
[null,"It was","2021-10-13",{"$f":"CONCATENATE(B8,\" \",TEXT(C8,\"DD-MMM-YYYY\"))","v":"It was 13-Oct-2021"},{"$f":"_xlfn.FORMULATEXT(D8)","v":"=CONCATENATE(B8,\" \",TEXT(C8,\"DD-MMM-YYYY\"))"}]
[null,"The year was","2020-10-14",{"$f":"CONCATENATE(B9,\" \",TEXT(C9,\"YYYY\"),\",\",\" the date was \",TEXT(C9,\"MMM DD\"))","v":"The year was 2020, the date was Oct 14"},{"$f":"_xlfn.FORMULATEXT(D9)","v":"=CONCATENATE(B9,\" \",TEXT(C9,\"YYYY\"),\",\",\" the date was \",TEXT(C9,\"MMM DD\"))"}]

{"sheet":"Combine Text and Numbers","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combine TEXT and Numbers in Desired Format"]
[]
[null,"Text","Numbers","Combined Format"]
[null,"You're due",2545,{"$f":"CONCATENATE(B5,\" \",TEXT(C5,\"$###,###.00\"))","v":"You're due $2,545.00"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=CONCATENATE(B5,\" \",TEXT(C5,\"$###,###.00\"))"}]
[null,"The discount is",0.7,{"$f":"CONCATENATE(B6,\" \",TEXT(C6,\"#%\"))","v":"The discount is 70%"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=CONCATENATE(B6,\" \",TEXT(C6,\"#%\"))"}]
[null,"Net Profit ",2653,{"$f":"CONCATENATE(B7,\" \",TEXT(C7,\"+ $#,##0.00;- $#,##0.00;$0.00\"))","v":"Net Profit  + $2,653.00"},{"$f":"_xlfn.FORMULATEXT(D7)","v":"=CONCATENATE(B7,\" \",TEXT(C7,\"+ $#,##0.00;- $#,##0.00;$0.00\"))"}]
[null,"Net Profit ",4582.5,{"$f":"CONCATENATE(B8,\" \",TEXT(C8, \"- $#,##0.00;- $#,##0.00;$0.00\"))","v":"Net Profit  - $4,582.50"},{"$f":"_xlfn.FORMULATEXT(D8)","v":"=CONCATENATE(B8,\" \",TEXT(C8, \"- $#,##0.00;- $#,##0.00;$0.00\"))"}]
[null,"We need oil",4582.5,{"$f":"CONCATENATE(B9,\" \",TEXT(C9,\"# ?/?\"),\" \",\"ounces\")","v":"We need oil 4582 1/2 ounces"},{"$f":"_xlfn.FORMULATEXT(D9)","v":"=CONCATENATE(B9,\" \",TEXT(C9,\"# ?/?\"),\" \",\"ounces\")"}]

{"sheet":"Leading Zeros","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Add Leading Zeros Using TEXT Function"]
[]
[null,"Product Code","Code with Leading Zeros"]
[null,2415,{"$f":"TEXT(B5,\"00000\")","v":"02415"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(B5,\"00000\")"}]
[null,4125,{"$f":"TEXT(B6,\"000000\")","v":"004125"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(B6,\"000000\")"}]
[null,6253,{"$f":"TEXT(B7,\"0000000\")","v":"0006253"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(B7,\"0000000\")"}]
[null,1475,{"$f":"TEXT(B8,\"00000000\")","v":"00001475"},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=TEXT(B8,\"00000000\")"}]
[null,4198,{"$f":"TEXT(B9,\"000000000\")","v":"000004198"},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=TEXT(B9,\"000000000\")"}]

{"sheet":"Phone Number","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Converting Phone Numbers Using TEXT Function"]
[]
[null,"Phone Number","Formatted Number"]
[null,8801721456023,{"$f":"TEXT(B5,\"(##) ### ### #####\")","v":"(88) 017 214 56023"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXT(B5,\"(##) ### ### #####\")"}]
[null,61491570110,{"$f":"TEXT(B6,\"(##) ### ### ###\")","v":"(61) 491 570 110"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=TEXT(B6,\"(##) ### ### ###\")"}]
[null,640287701142,{"$f":"TEXT(B7,\"(##) ### ### ####\")","v":"(64) 028 770 1142"},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=TEXT(B7,\"(##) ### ### ####\")"}]
[null,12025550115,{"$f":"TEXT(B8,\"(##) ### ### ####\")","v":"(1) 202 555 0115"},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=TEXT(B8,\"(##) ### ### ####\")"}]
[null,9101155178409,{"$f":"TEXT(B9,\"(##) ### ### #####\")","v":"(91) 011 551 78409"},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=TEXT(B9,\"(##) ### ### #####\")"}]

{"sheet":"Change font","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Changing Fonts in Excel"]
[]
[null,"Books"]
[null,"The Wind in the Willows"]
[null,"The Very Hungry Caterpillar"]
[null,"Harry Potter and \nthe Sorcerer's Stone"]
[null,"Percy Jackson and \nthe Lightening Thief "]

{"sheet":"Bold italic & underline","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Apply Bold, Italic and Underline to Text"]
[]
[null,"Books"]
[null,"The Wind in the Willows"]
[null,"The Very Hungry Caterpillar"]
[null,"Harry Potter and \nthe Sorcerer's Stone"]
[null,"Percy Jackson and \nthe Lightening Thief "]

{"sheet":"Change font size","index":8,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Changing Font Size in Excel"]
[]
[null,"Books"]
[null,"The Wind in the Willows"]
[null,"The Very Hungry Caterpillar"]
[null,"Harry Potter and the Sorcerer's Stone"]
[null,"Percy Jackson and the Lightening Thief "]

{"sheet":"Change font color","index":9,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Changing Font Color in Excel"]
[]
[null,"Books"]
[null,"The Wind in the Willows"]
[null,"The Very Hungry Caterpillar"]
[null,"Harry Potter and the Sorcerer's Stone"]
[null,"Percy Jackson and the Lightening Thief "]

{"sheet":"format part of cell","index":10,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Formatting Part of Cell in Excel"]
[]
[null,"Books"]
[null,"The Wind in the Willows"]
[null,"The Very Hungry Caterpillar"]
[null,"Harry Potter and the Sorcerer's Stone"]
[null,"Percy Jackson and the Lightening Thief "]

{"sheet":"VBA FORMAT Function","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Number Format using VBA FORMAT Function"]
[]
[null,"Numbers","Format"]
[null,2545,2545]
[null,1.5,1.5]
[null,2653,2653]
[null,4856,"1913-04-17"]
[null,4825,"Monday, March 17, 1913"]

{"sheet":"Sheet1","index":12,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[]
[null,"Excel Text Format"]
[]
[null,"Without Formatting","With Formatting"]
[null,1.5,{"$f":"TEXT(B5,\"#%\")","v":"150%"}]
[null,"2023-10-10",{"$f":"TEXT(B6,\"DD MMM,YYYY\")","v":"10 Oct,2023"}]
[null,6253,{"$f":"TEXT(B7,\"0000000\")","v":"0006253"}]
[null,"The Wind in the Willows","The Wind in the Willows"]
[null,"Percy Jackson and \nthe Lightening Thief ","Percy Jackson and \nthe Lightening Thief "]
[null,"Harry Potter and the Sorcerer's Stone","Harry Potter and the Sorcerer's Stone"]