You're a finance analyst importing 12 transaction amounts from a PDF export. Column A holds the amounts as strings with dollar signs and thousands-separators: "$1,234.56", "$10,000.00". Downstream calculations need the values as plain numbers.
Your task:
- In column B (Numeric Value), write a formula that converts each string to a number.
- The formula must drag-fill from B2 → B13.
The two acceptable patterns:
- SUBSTITUTE chain + VALUE:
=VALUE(SUBSTITUTE(SUBSTITUTE(A2, "$", ""), ",", "")) — strip the $ and , characters, then VALUE coerces the resulting clean number-looking string to a real number.
- NUMBERVALUE:
=NUMBERVALUE(SUBSTITUTE(A2, "$", "")) — NUMBERVALUE interprets thousands separators directly.
Graded cells: B2 ("$1,234.56" → 1234.56), B4 ("$10,000.00" → 10000), B6 ("$0.99" → 0.99).
Open this problem on a desktop to attempt it.