Excel Video 217 has some easy ways to format numbers and dates in Excel. Do you want to put a dollar sign in front of your number? Add a comma as a thousands separator? Display a number as a percentage? Increase or decrease the number of places after the decimal? All of those changes are a click away in Excel Video 217.
We’ll discuss the difference between the Accounting format and the Currency format, how to make .6 display as 3/5, and how to include the day of the week when displaying the date. These tricks will probably solve most of your number and date formatting needs. Custom number formats can also be very helpful, especially when it comes to dates and times. We’ll work on custom number formats next time.