Convert to Numbers
Use this when an export looks numeric but Excel treats it as text.
Explore ↗Turn text into numbers, split mixed columns, fix signs, find duplicates and save a monthly routine.
Open the file you already use and start with a task you repeat.
Use this when an export looks numeric but Excel treats it as text.
Explore ↗Use this when one field contains multiple pieces of information.
Explore ↗Use this when you need to inspect possible duplicate rows.
Explore ↗Use this when imported amounts have the opposite sign to the view you need.
Explore ↗Use this to work with dated transactions by period.
Explore ↗Describe it. Teach it. Save it for next month.
Explore ↗A safe sample shows the kind of result to expect.
| Invoice | Imported amount | Format |
|---|---|---|
| INV-101 | '1 250.00 | Text → number |
| INV-102 | '430.50 | Text → number |
| INV-103 | '2 100.00 | Text → number |
Select the button to see the before and after.
The same exports, checks and reports come back every month. Start with the task that takes up your time.
Fix spacing, formats and values before the analysis begins.
Explore data cleaning tools ↗Review differences between workbook versions and supporting files.
Explore comparison apps ↗Describe the steps, test your macro and save a routine for the next file.
Explore Macro Wizard ↗Use repeatable checks to help identify differences for review.
Find checking tools ↗Less repeated preparation. More time to understand the results.
Start your 10-day trialStart with the current 10-day trial, or speak to us about what your team needs.