1. Standardizing Data Entry
Data AnalystBackground
A dataset imported from a legacy system contains fullwidth numbers (123) that prevent mathematical calculations.
Problem
The system does not recognize fullwidth digits as valid numeric values.
How to use
Paste the data into the input field, select 'Numbers Only' mode, and convert.
conversionMode: numbers, preserveLineBreaks: trueOutcome
The numbers are converted to standard ASCII digits, allowing the spreadsheet software to perform calculations correctly.