When a formula expects a number, Excel converts text if it is in a format that would usually be accepted for a number. = "6/1/2001"-"5/1/2001" 31. Excel interprets the text as a date in the mm/dd/yyyy format, converts the dates to serial numbers, and then calculates the difference between them. =SQRT ("8+1") #VALUE! Excel cannot convert the ...

From the Header & Footer Ribbon menu, click Insert Date or Insert Time.You can also insert the Page Number, Number of Pages, File Path, File Name and Sheet Name.

Change the date or time format. To change the date or time format, right-click on a cell, and select Number Format. Then, on the Number Format dialog box, under Category, click Date or Time and in the Type list, select a type, and click OK.

Note: The Excel Workbook Gallery replaces the former Chart Wizard. By default, the Excel Workbook Gallery opens when you open Excel. From the gallery, you can browse templates and create a new workbook based on one of them. If you don't see the Excel Workbook Gallery, on the File menu, click New from Template.

Excel provides a special number format that lets you format a number as a phone number. For example, you can format a 10-digit number, such as 5555551234, as (555) 555-1234. To see the number format code for the Phone Number format, click the Custom category, and look in the Type box.

Select the Date and time check box, and then do one of the following: If you want the date and time to reflect the current date and time each time you open or print the presentation, click Update automatically, and then select the date and time format that you want .

Credit card numbers are rounded down. Excel has a maximum precision of 15 significant digits, which means that for any number containing 16 or more digits, such as a credit card number, any numbers past the 15th digit are rounded down to zero. In the case of number codes that are 16 digits or larger, you must use a text format.

Add a scroll bar or spin button to an Excel worksheet. The controls let you quickly enter or change a range of values. ... such as a number increment, time, or date. To increase the value, click the up arrow; to decrease the value, click the down arrow. ... and then click Format Control.

There are a lot of formatting options for data labels. You can use leader lines to connect the labels, change the shape of the label, and resize a data label. And they’re all done in the Format Data Labels task pane.

Learn how to use Excel to create a calendar by using a template. ... to a calendar. Calendar templates are formatted by using themes that enable you to apply fonts, colors, and graphic formatting effects throughout the workbook with just a click. ... or find options to change just the theme fonts or theme colors. Important: Formulas exist in ...