How can to convert numbers in Excel to hundred normal and (K) to thousand and (M) to Milion and (B) to Billion
like the below
enter image description here
and i used this format but give all hundred number with (K)
[<100000]0.00,”K”;[<100000000]0.00,,”M”;0.00,,,”B”
enter image description here
i need formating like the below image
enter image description here
New contributor
user25863538 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.