Forum Discussion
Trying to make Excel convert large numbers to K, M and B
As the title explains, I'm trying to use the Format Cells function to convert large numbers to shortened versions. It works with M and K, but when I try to add B it gives an error.
[>=1000000] 0,0..\M;[>=1000] 0,0.K; 0
This one works perfectly for millions and thousands
[>=1000000000] 0,0...\B;[>=1000000] 0,0..\M
This works perfectly as well, for billions and millions.
Now when I try to combine those two like this;
[>=1000000000] 0,0...\B;[>=1000000] 0,0..\M;[>=1000] 0,0.K; 0
Excel says it can't be used. Can anyone identify where the error is?
1 Reply
It is a limitation of Excel cell formatting. When we use the form field1;field2;field3 , we are limited to 3 fields.
Use Conditional Formatting for more than 3 alternatives.
