 Using Text to Columns to Convert Text to Dates
Summary: Working with dates requires those dates to be in an Excel Date format. Here is how to convert a text date to one of the many Excel date formats:
- Select the range of text dates.
- Click the Data tab.
- Select Data Tools | Text to Columns and a wizard dialog box will open.
- In the wizard dialog box, click Next twice to go to Step 3 of the Wizard.
- Use the default settings in the first two steps of the wizard.
- In Step 3 of the wizard, select the Date option and select your desired format.
- Click Finish and the text dates will convert to dates that can be formatted and used in calculations.
|
Quickly Creating a Numbered or Bulleted List
Summary: We often use numbered and/or bulleted lists in a Word document. You can add them from the ribbon, but here's a neat shortcut to add them from the keyboard.
To create a numbered list type a number with a period and then a space at the beginning of the sentence. After you enter your text for the first number press Enter and Word will move down a row and enter the next number.
To create a bulleted list type "*" and then a space at the beginning of the sentence. After you enter your text for the first bullet press Enter and Word will move down a row and enter the next number.
It's that easy.
|
