ExcelNumberFormat
ExcelNumberFormat copied to clipboard
Support rounding numbers from format
Suggest a new NumberFormat.Round() method to return numeric inputs as numbers still, but with number formatting rules applied - i.e round to number of decimals, percent multiply, thousands division.
F.ex the number 0.02345 returns different values depending on the format:
| Number format | Round(0.02345) output |
|---|---|
| 0% | 2 |
| 0.00000, | 0.00002 |
| 0.00 | 0.02 |
This helps for cases when the user wants to insert the "visual part" of a value into a numeric database field.