75 Essential Excel tips

You can also format cells as text as you type. For example, if you enter the ZIP code value 08053, Excel formats it as the number 8053 by default. To configure Excel to format it as text, enter an apostrophe ['] before the value. In this case, typing '08053 formats the cell as the text value 08053. Analyzing external data in Excel ................
................