4 Simple Ways to Insert Current Date and Time in Spreadsheet

Kingsoft Spreadsheets has always been one of my favorite tools. I was an early adopter and it has always been the most reliable tool for me, and there are plenty of hidden features inside Kingsoft Spreadsheets you may be amazed to discover.

Here today I summarize 4 ways to insert date in spreadsheet. I'll explain them in details as following.

1. Use shortcut to insert date and time

Although you could enter the date and time directly in the cell, that’s not the quickest way I think. Here I’ll introduce the shortcut to do that:

“Ctrl”+”;” for current date

“Ctrl”+”’” for current time

If you would like to insert current date and time at the same time, you can check the formula way below.

2. Use formula to insert date and time

Note: Using the formula way you can real-time update the date. Only thing you need to do is using F9 to refresh it.

That means, if you plan to edit your document on a regular basis (to update the task statuses, for example), this is not going to be an issue using the formula way. However, in other ways unless you make any edits to the document, you are not going to see the current date and time.

Formula “=today()”

Formula ”=now()”



3. Enter other types of date

Use Ctrl+1 to open the Format Cells, choose Custom and enter the format you want in the Type, for example m"."d"."yyyy;@, then you can enter 3.25.2013 in the cell.



4. Set the date format

Like you did as front, you can set the date format in the Date option by opening the Format Cells.

Thanks for "install" Microsoft Office

We use Kingsoft Office, a free alternative to the Microsoft Office suite. During the years we've used it, we've only had a few instances (in the accounting dept, usually) when we've had to buy the 'real' Office mostly due
to complex macros that had to run.

Whenever anybody insists that he need the Microsoft Office, we ask him to justify the expense and it usually turns out to be something along the lines of 'Well, I like it better'. The request is denied and after a few weeks the user realizes that Kingsoft Office is just as good for typing their shopping list.

Well, we have one user who kept insisting that ONLY the latest and greatest Microsoft Office would do, because he was a 'power user' and needed all of the advance features.

I delayed (frankly, I got tied up in something else and honestly forgot his request) until he eventually stopped me in the corridor one day and.... thanked me for installing MS Office for him while he was on vacation!
I was confused, so went to look at his computer. Nope, still had just Kingsoft Office on it. He'd finally opened it for the first time and, power user as he is, never even noticed that it wasn't the Microsoft product. He thought he'd won the game and that we'd given in and bought him Word and Excel.

I just shook my head, told him 'You're welcome' and left it at that. Another satisfied and valued power user.

How to Extract All Email Addresses in a Word Document in One Second

One day, your boss gives you a document and asks you to extract all the email addresses in it. The fact is, unfortunately, there are hundreds of email addresses mixed up in the text! So how can you complete this job? Will you check all the addresses one by one? Of course not. Let me tell you a quite simple and fast way to do it in one second. Take Kingsoft Writer 2013 as an example:

Step1. Press the shortcut Ctrl+F to bring up the "Find and Replace"panel.



Step 2. Type “[A-z,0-9]{1,}\@[A-z,0-9,\.]{1,}” in Find what (without double quotes). Then check “Highlight all items found in”, and click "More" to check “Use wildcards”.



Step 3. Click “Find all” and you will pick out all email addresses at one time. See the following:



In this way, the work that may take you three days can be done in a second, improving your work efficiency and saving your time and effort.