Here today I summarize all the ways to input date in the Kingsoft spreadsheet, either quick ways, the normal ways or the advanced ways. I'll explain them in details as following:
Enter date directly and fast
A.Use the keyboard shortcuts:
Ctrl+; for current date
Ctrl+' for current time
B.Enter in the cells directly
3/25/2013 or 3-25-2013
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.
Set the date format
Like you did as above, you can set the date format in the Date option by opening the Format Cells.
Use formula to enter date
Besides the above ways to enter date in spreadsheet, you can also use formula to achieve this, and in this way you can real-time update the date.
Formula=today( )
Formula=now( )
And don't forget to use F9 to refresh it!
No comments:
Post a Comment