Round up function

Dear Shane

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


Please select all the values that have Million figures in it.

Format > Cells... from the Menu Bar

Choose Custom from the Number tab

In the They box enter the following:

#,##0,, "Mil" ;[Red](#,##0,,);- ;

Note: you can simply copy and paste the above custom format. (CTRL +C (Copy) and CTRL +V (Paste)


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT