Selecting cells that only contain Text in Microsoft Excel

By selecting cells that only contain text, you can distinguish between cells containing different types of data, which allows you to delete, fill or lock cells by type.
Technique 1

Press F5, or choose Edit, Go To…;
In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.


Technique 2 - Conditional
Formatting

Select the data area.
From the Format menu, select Conditional Formatting.
In Condition 1, select Formula Is.
In the Formula Box, enter the formula =Istext(A1).
Click Format..., choose any format from the Format Cells dialog box, and click OK.
Click OK.

Using keyboard shortcuts to open the Insert Function dialog box:

Select an empty cell and press Shift+F3.
To open a Function Arguments dialog box:
Select a cell containing a formula and press Shift+F3.

To insert a new Formula into a cell using the Function Arguments dialog box:

1. Select an empty cell, and then type the = sign.
2. Type the formula name and press Ctrl+A.

To insert a formula by typing it while being guided by the formula syntax tooltip:

1. Select an empty cell, and then type the = sign followed by the formula name and a ( sign.
2. Press Ctrl+Shift+A (in Excel version 2003 the syntax appears immediately after step 1 above)

Change slash separator in date with period in Microsoft Excel

Some times most people love to use period instead of / and would like to change the default setting for the date format, perform the following steps:

From Windows, choose Start, Settings, Control Panel, Regional Options.

Select the Date tab. In the Date separator box, change the slash (/) to a period (.).

Click Apply and OK