Using the code [>=1000000000]#,##0,,,”B”;[>=1000]#,##0,”K”;0 will show 100 to 100K, followed by 1000K. I want 1000k as 1M. 10,000k as 10M, then 100,000k as 10M.enter image description here Don’t have issues at 1 G and 10G.
Tryingenter image description here this code [>=1000000]#,##0,,”M”;[>=1000]#,##0,”K”;0 will this image.enter image description here
1G was replaced with 1,000M and 10G becomes 10,000M. I’m expecting to be 1G and 10G from previous graph.
New contributor
Rod Gayutin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.