Excel has some cool formatting tricks up its sleeve and one of these is its ability to shrink really big numbers down to size.
So, if you have values in the millions – like your salary – Ha!, you can size them down to size using a custom format. Select the cells, choose Format, Cells, Number tab and click the Custom group and type #,,”M” and Excel will format 200,000,000 to read 200M! The numbers aren’t altered it’s just a simpler way of displaying them.
Since the Y axis of a chart inherits its formatting from the top left cell in the chart data range this lets you format a chart’s Y axis to show the smaller values too.
the so called rounded up is only for the display, i need the real rounded up function. here’s the situation, i’ve 2 sets of data and i have to cross check them. 1 comes in millions and another is not. so if i use the function of “IF” in excel, it shows false result. so i need to make both sets of data in same unit of millions for the well function of “IF”.