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.