CleanMySheet guide
Convert European number format to 1234.56
The European number format preset treats dot as thousands and comma as decimal. Accounting parentheses still mean negative. Clean numbers auto-detects Indian 1,23,456.78, EU 1.234,56, and US 1,234.56, and strips ₹ / Rs / INR as well as $ € £ ¥.
Finance pack will be suggested after scan.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Upload
- Search “europe” or European number format
- Confirm Diff
- Export
Auto-detect vs override
Clean numbers infers Indian, EU, or US grouping from the column. Use European number format when you want to force 1.234,56 parsing.
Related searches this page answers
- european number format csv
- convert comma decimal excel
- 1.234,56 to number