Wad Mabbit
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
I'd like numbers for format in 0.00T, 0.00B, 0.00M and 0.00K
But um, I guess I've messed up pushing it to Kilo.
This works
[>999999999999]0.00,,,,"T";[>999999999]0.00,,,"B";0.00,,"M"
This doesn't work for me...
[>999999999999]0.00,,,,,"T";[>999999999]0.00,,,,"B"[>999999]0.00,,,"M";0.00,,"K"
(Excel 2016)
Have I missed something?
But um, I guess I've messed up pushing it to Kilo.
This works
[>999999999999]0.00,,,,"T";[>999999999]0.00,,,"B";0.00,,"M"
This doesn't work for me...
[>999999999999]0.00,,,,,"T";[>999999999]0.00,,,,"B"[>999999]0.00,,,"M";0.00,,"K"
(Excel 2016)
Have I missed something?