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,...
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.