Excel tips : How to insert date in a cell

Last update on August 1, 2009 12:52 PM by jak58
Published by aakai1056



Excel tips : How to insert date in a cell




Below are some tips on how to insert date and time in an excel cell for a specific purpose:-

To insert current date, press CTRL ¯+ ;¯ in the chosen cell.

To insert current time, press CTRL¯+ SHIFT¯+ ;¯.

To insert current date and time together, press
 CTRL¯+ ;¯ SPACEBAR¯+ CTRL+¯SHIFT¯+ ;
Best answers for « Excel tips : How to insert date in a cell » in :
How to merge an excel file to database? (Solved) Show
Inserting an animated gif in Excel Show Inserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Excel make cell flash red (Solved) Show
[Acrobat Tips] Insert a photo in a pdf Show[Acrobat Tips] Insert a photo in a pdf Issue Solution Issue How to insert a photo scanned into a PDF document with Adobe Acrobat Solution In the toolbar, look for "Document" and select "Watermark" and "add". In the new window...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
They need your help