What's the Current Date or Time?

What's the Current Date or Time?

You may be familiar with Excel's NOW function, which plugs the current date and time into your spreadsheet. Just enter =NOW() into any cell, and Excel displays the date and time formatted according to the regional options you've set for Windows. If you just want to see the date, use the TODAY function, =TODAY(), instead.

But if you want to use either of these functions as a type of "timestamp" you'll find that they don't do the job, because they're automatically updated whenever your worksheet is calculated or re-opened. The cell that displays today's date will display tomorrow's date when you open the spreadsheet tomorrow.

To insert a fixed date into a cell--a date that you don't want to change--hold down Ctrl while you press the semicolon ( ;) key. To insert the current time (without a date), press Ctrl-Shift-Semicolon.

These commands are useful if you like to document your work. For example, you might want to keep track of when you added new data to your worksheet.

Removing Extra Breaks in Word Documents

Removing Extra Breaks in Word Documents


Follow these steps:

1. Press Ctrl + H to open the Find and Replace dialog box

2. In the first box, enter ^p^p (the "p" must be lower case)

3. In the second box, enter ^p

4. Click Replace All

Note: This will replace two paragraph breaks with one. You can specify other options, depending on the number of paragraph breaks you'd like between paragraphs. You can also replace a paragraph break with another character, if you choose.

If you copied the text from the Internet, this might not work for you. That's because there are different types of breaks in HTML files. Not to worry, there is a solution:

5. Press Ctrl + H to open the Find and Replace dialog box

6. In the first box, enter ^l (the "l" must be lower case)

7. In the second box, enter ^p

8. Click Replace All

You can then replace double breaks as necessary.