Posted 3 January 2019, 3:15 am EST
Is there any way to format number this way:
- having thousand spearators
- having 0-4 digits after comma
Examples:
7598347.24342 → 7,598,347.2434
2344.3 → 2,344.3
100 → 100
Tried N4 but it gives fixed number of digits after comma:
2344.3 → 2,344.3000
100 → 100.0000
Looks like “#,##0.00” is not supported