BigBeachBananas
Active Member
- Joined
- Jul 13, 2021
- Messages
- 450
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi all,
I have the following issue with formatting numbers.
Sample positive numbers:
Current cell format: [>=1000000000]$#,##0.0,,,"B";[>=1000000]$#,##0.0,,"M";$#,##0.0,"K"
Sample positive output:
My issue is with the negative values.
Notice the Millions and Billions are not rounded correctly as the positive version.
I have the following issue with formatting numbers.
Sample positive numbers:
12.6357 | 12635.7 | 12,635,703.92 | 12,635,703,916.48 |
Current cell format: [>=1000000000]$#,##0.0,,,"B";[>=1000000]$#,##0.0,,"M";$#,##0.0,"K"
Sample positive output:
$0.0K | $12.6K | $12.6M | $12.6B |
My issue is with the negative values.
$0.0K | -$12.6K | -$12,635.7K | -$12,635,703.9K |
Notice the Millions and Billions are not rounded correctly as the positive version.