[Excel] Adding a fixed date in a cell

Last update on December 7, 2008 10:57 AM by netty5
Published by netty5

[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 cell selected.

The same goes for, inserting the time in HH: MM:
Simply type "ctrl" + ":" in cell
Best answers for « Adding a fixed date in a cell » in :
Having a fix IP address under Windows XP Show Having a fix IP address under Windows XP Often, it is necessary to have a fixed IP address, especially in cases where there is a network of several PCs at home. This requires this information by doing: Start Run and type...
Fixed IP or Dynamic IP address Show Fixed IP or Dynamic IP address What is fixed IP / dynamic? Chosing your IP address Obtaining a fixed IP address What is fixed IP / dynamic? A fixed IP is different to a dynamic IP in the sense that the your service provider assigns the...
Moving data to the next empty cell Show
Do you need a fix IP for remote connection? ShowDo you need a fix IP for remote connection? Myth Truth How does it work? An Internet Service Provider will usually provide a user with a fix IP address that cannot be changed by the user himself. This number is used by another...
Excel - Using IF statement to add 1 to total ShowExcel - Using IF statement to add 1 to total Issue Solution Note Issue I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then add + 1 to cell B35. If...
Excel tips : How to insert date in a cell ShowExcel 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¯+...
Download Address Book Recovery Show
Download Telist Pro Show
Download TClockEx ShowTclockEx enhances Windows taskbar clock. In addition to the displayed hour, you can add the date with day, month and year or other supplementary information (the size of the available disk, the used memory). TclockEx is totally customizable: you can...
Random access memory (RAM or PC memory) ShowTypes of random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static...
Whois ShowWhois "Whois" is a tool for querying information bases (called registries) regarding domain names and IP addresses. The data contained in these registries bears no guarantee, but may generally be used to find out who owns a domain name or a...
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