Custom cell formatting in Excel [SOLVED]

[madocar]

Hello guys,


I'm just curious how to change cell format.

Imagine the number 2 163 244. And I would like to change the format to this result 2.1M


Any advice please?


Thanks

 

[NARAYANK991]

Hi ,


Check this link :


http://www.accountingweb.co.uk/anyanswers/displaying-numbers-millions-format


http://smallbusiness.chron.com/format-excel-millions-29107.html


Narayan

 

[Hui]

use a Custom number format of #,,.#

 

[jeffreyweir]

If you want the M to populate, change Hui's to this:

use a Custom number format of #,,.#"M"

 

[madocar]

Thank you guys!