Get instant live expert help on I need help with excel format millions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
how do i convert a number in millions to 1.1m using formatting i,e, 2000000 to 2.0
Solved by K. B. in 11 mins
I need to change the increments in my scatter plot in the most recent version of excel, the only options I am given is default, thousands, millions, billions, and log. I need custom increments.
Solved by G. J. in 17 mins
I have an Excel data analysis assignment. I have to rearrange figures from World Bank's # of poor from millions to billions. I need a simple way because I have to create an Other Developing Regions category and calculate how many poor for that region.
Solved by M. D. in 27 mins
I am trying to create a custom number format that applies M for millions and K for thousands, and that also varies the number of decimal places as the numbers get bigger. This is where I am at at the moment [>=1000000]#.00,"M";[>=100000]#,"K";[>=1000]#.0,"K; but this format doesnt seem to process. Here are some example numbers of the format I am going for (zero to be invisible) 3 36 365 3.65K 36.5K 365K 3.65M 36.5M Any help with this issue would be greatly appreciated.
Solved by Z. Y. in 25 mins
I have a format that is a source format, and I would like to have an output in a different format. advanced formula excel is required.
Solved by K. J. in 11 mins