{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","apostrophe","Format Cells","TEXT","IF","VBA"],"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":"Overview","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Convert Number to Text with 2 Decimal Places"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",450.65,{"$f":"TEXT(C5,\"##0.00\")","v":"450.65"}]
[null,"Guava",320.5,{"$f":"TEXT(C6,\"##0.00\")","v":"320.50"}]
[null,"Grape",240,"240.00"]
[null,"Orange",250,"250.00"]
[null,"Grape",200.05,"200.05"]
[null,"Blueberry",250.05,"250.05"]
[null,"Pineapple",300.00049999999999,"300.00"]
[null,"Coconut",180.56,"180.56"]
[null,"Banana",320.04500000000002,"320.05"]

{"sheet":"apostrophe","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use Apostrophe to Convert Number to Text"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",450.65,"450.65"]
[null,"Guava",320.5,"320.50"]
[null,"Grape",240,"240.00"]
[null,"Orange",250,"250.00"]
[null,"Grape",200.05,"200.05"]
[null,"Blueberry",250.05,"250.05"]
[null,"Pineapple",300.00049999999999,"300.00"]
[null,"Coconut",180.56,"180.56"]
[null,"Banana",320.04500000000002,"320.05"]

{"sheet":"Format Cells","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply Format Cells to Convert Number to Text"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",450.65,450.65]
[null,"Guava",320.55,320.55]
[null,"Grape",240.57,240.57]
[null,"Orange",250.05,250.05]
[null,"Grape",200.05,200.05]
[null,"Blueberry",250.05,250.05]
[null,"Pineapple",300.05,300.05]
[null,"Coconut",180.56,180.56]
[null,"Banana",320.04000000000002,320.04000000000002]

{"sheet":"TEXT","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"TEXT Function to Convert Number to Text"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",450.65,{"$f":"TEXT(C5, \"##0.00\")","v":"450.65"}]
[null,"Guava",320.5,{"$f":"TEXT(C6, \"##0.00\")","v":"320.50"}]
[null,"Grape",240,"240.00"]
[null,"Orange",250,"250.00"]
[null,"Grape",200.05,"200.05"]
[null,"Blueberry",250.05,"250.05"]
[null,"Pineapple",300.00049999999999,"300.00"]
[null,"Coconut",180.56,"180.56"]
[null,"Banana",320.04500000000002,"320.05"]

{"sheet":"IF","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use the IF Function to Convert Number to Text"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",420.5,{"$f":"IF(CELL(\"FORMAT\",C5)=\"F2\", TEXT(C5,\"0.00\"), TEXT(C5,0))","v":"420.50"},null,{"$f":"IF(CELL(\"FORMAT\",C5)=\"F3\", TEXT(C5,\"0.000\"), TEXT(C5, 0))","v":"421"}]
[null,"Guava",320.49,{"$f":"IF(CELL(\"FORMAT\",C6)=\"F2\", TEXT(C6,\"0.00\"), TEXT(C6,0))","v":"320.49"}]
[null,"Grape",240,{"$f":"IF(CELL(\"FORMAT\",C7)=\"F2\", TEXT(C7,\"0.00\"), TEXT(C7,0))","v":"240.00"}]
[null,"Orange",250,{"$f":"IF(CELL(\"FORMAT\",C8)=\"F2\", TEXT(C8,\"0.00\"), TEXT(C8,0))","v":"250.00"}]
[null,"Grape",200.05,{"$f":"IF(CELL(\"FORMAT\",C9)=\"F2\", TEXT(C9,\"0.00\"), TEXT(C9,0))","v":"200.05"}]
[null,"Blueberry",250.05,{"$f":"IF(CELL(\"FORMAT\",C10)=\"F2\", TEXT(C10,\"0.00\"), TEXT(C10,0))","v":"250.05"}]
[null,"Pineapple",300.00049999999999,{"$f":"IF(CELL(\"FORMAT\",C11)=\"F2\", TEXT(C11,\"0.00\"), TEXT(C11,0))","v":"300.00"}]
[null,"Coconut",180.56,{"$f":"IF(CELL(\"FORMAT\",C12)=\"F2\", TEXT(C12,\"0.00\"), TEXT(C12,0))","v":"180.56"}]
[null,"Banana",320.04500000000002,{"$f":"IF(CELL(\"FORMAT\",C13)=\"F2\", TEXT(C13,\"0.00\"), TEXT(C13,0))","v":"320.05"}]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Run a VBA Code to Convert Number to Text"]
[]
[null,"Product","Price","Number to Text"]
[null,"Apple",450.65,{"$f":"TEXT(C5,\"##0.00\")","v":"450.65"}]
[null,"Guava",320.5,{"$f":"TEXT(C6,\"##0.00\")","v":"320.50"}]
[null,"Grape",240,"240.00"]
[null,"Orange",250,"250.00"]
[null,"Grape",200.05,"200.05"]
[null,"Blueberry",250.05,"250.05"]
[null,"Pineapple",300.00049999999999,"300.00"]
[null,"Coconut",180.56,"180.56"]
[null,"Banana",320.04500000000002,"320.05"]