{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["extract-numbers"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"extract-numbers","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Extracting Numbers from Text using Macros"]
[]
[null,"Text","Number"]
[null,"749000 INR",{"$f":"[1]!getNumber(B4)","v":749000}]
[null,550000,{"$f":"[1]!getNumber(B5)","v":550000}]
[null,1000000,{"$f":"[1]!getNumber(B6)","v":1000000}]
[null,"900000 INR",{"$f":"[1]!getNumber(B7)","v":900000}]
[null,"Rs 600000",{"$f":"[1]!getNumber(B8)","v":600000}]
[null,500000,{"$f":"[1]!getNumber(B9)","v":500000}]
[null,800000,{"$f":"[1]!getNumber(B10)","v":800000}]
[null,"61.000,00",{"$f":"[1]!getNumber(B11)","v":61000}]
[null,500000,{"$f":"[1]!getNumber(B12)","v":500000}]
[null,"US $ 31,330.00",{"$f":"[1]!getNumber(B13)","v":31330}]
[null,2300000,{"$f":"[1]!getNumber(B14)","v":2300000}]
[null,800000,{"$f":"[1]!getNumber(B15)","v":800000}]
[null,"Rs. 1300000",{"$f":"[1]!getNumber(B16)","v":1300000}]
[null,13636.36,{"$f":"[1]!getNumber(B17)","v":13636.36}]
[null,"INR18Lacs or US$36000",{"$f":"[1]!getNumber(B18)","v":1836000}]
[null,"INR 500000",{"$f":"[1]!getNumber(B19)","v":500000}]
[null,"52500.00 USD",{"$f":"[1]!getNumber(B20)","v":52500}]