DATE Function
The DATE function creates a date using individual year, month, and day arguments. Each argument is provided as a number, and the result is a serial number that represents a valid Excel date. Apply a date...Read more
Dave Bruns
How to use special formatting in Excel
In this video we show you how to use the special number formats built into Excel, including phone numbers, zip codes, and social security numbers.
How to use text formatting in Excel
In this video we show you how to format numbers as text. This is useful for part numbers, zip codes, and other numbers that start with zero.
How to use scientific formatting in Excel
In this video we show you how to format numbers in scientific notation.
How to use fraction formatting in Excel
In this video we show you how to format numbers as fractions.
How to use percentage formatting in Excel
In this video we show you how to use the Percentage number format.
How to use date formatting in Excel
In this video we show you how to format dates in a variety of ways.
How to use accounting formatting in Excel
In this video we show you how to use the Accounting number format.
How to use currency formatting in Excel
In this video we show you how to use the currency number format.
How to use number formatting in Excel
In this video we show you how to format numbers with the basic number format.