[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 :
Excel: If date >= 30 days, cell change color (Solved) Show
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...
Custom CELL Address to Field Value 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 Advanced Tracks Cleaner 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...
Download Symphonic Contact Show
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...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
They need your help