Here is what I want to accomplish:
Value Display
1 1
11 11
111 111
1111 1.11k
11111 11.11k
111111 111.11k
1111111 1.11M
11111111 11.11M
111111111 111.11M
1111111111 1.11B
11111111111 11.11B
111111111111 111.11B
This is the format that a Bloomberg terminal uses to display currency figures. Numbers don't go past B.
Here is what I have tried so far:
[>999999999.999]#,,,"B";[>999999.999]#,,"M";#,##0_M
I stole it from here and I cannot find documentation that shows how to improve it.