Formatting Numbers

Formatting Excel XP numbers can improve how your spreadsheet looks. Use the number function in Excel XP to also better organize content.

Challenge!

  • Type a number in cell B2 and format it to have four decimal places.
  • Type a date in cell B3 and format it to look like October 6, 2003.
  • Type a time in cell B4 and format it to look like 1:30:00 AM.
  • Type a large number in cell B5 and a smaller number in cell C5. In cell D5, define a formula to divide cell B5 by cell C5. Format the answer in cell D5 to be a percentage with one decimal place.