Turning Number Text into a Number
Key points
- Choose VALUE
- Enter the cell
- Copy it
In Text to Date Builder you can build a formula that turns number text into a number you can calculate with.
Steps
- Choose VALUE
- Enter the cell
- Copy it
Use it when a total comes out as 0.
Use "Build a Text to Date Formula" (free)
Tools that go well with this
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- Build an Excel TEXT Formula: Build a TEXT formula.
- Build a Date Offset Formula: Build date offset formulas.