Excel spreadsheet - how to format numbers to say millions

tv3tg4 · 2016-10-17 18:05:55

Doing an assignment- the figures involved are big. Many of the number s are millions and billion s - is there a way in excel to format cells to work then in millions?

17-10-2016 07:05PM

#1

tv3tg4

Registered Users, Registered Users 2 Posts: 554 ✭✭✭

Join Date: April 2013

Posts: 452

Doing an assignment- the figures involved are big. Many of the number s are millions and billion s - is there a way in excel to format cells to work then in millions?

0

Comments

#2 17-10-2016 07:25PM

bee06

Registered Users, Registered Users 2 Posts: 4,514 ✭✭✭

Join Date: January 2013

Posts: 4033

Go to the number formats on the Home ribbon, select More Number formats on the drop down. In the pop up window select Custom and in the box under where is says Type: put

#,##0.00,, "M"

This will format 1 million as 1.00M

If you don't have any numbers smaller than 1million then you could leave out the .00

0