Formatting Excel XP numbers can improve how your spreadsheet looks. Use the number function in Excel XP to also better organize content.
- 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.