Microsoft Excel – Apply number formatting



  • Download the file used in the video.
  • Apply Number Formatting to all the Costs in column D.
  • Also format all the blank cells in the Discount column using Number Formatting.
  • In Sheet2 apply Number Formatting to many columns.
  • Test this out then apply Number Formatting to the entire sheet.
  • Close the file (you don’t need to save the changes).
  • Download the exercise file then follow the instructions in the yellow box.