If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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?

Options

17-10-2016 7:05pm

#1

tv3tg4

Registered Users Posts: 527 ✭✭✭

Join Date: April 2013

Posts: 427

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

Options
#2 17-10-2016 7:25pm
bee06

Registered Users 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