In Excel for Microsoft 365 on Windows, press Ctrl+; to enter today’s date as a fixed value, or Ctrl+Shift+; to enter the current time as a fixed value. To display a live date and time that can update when Excel recalculates, enter =NOW(). The right choice depends on whether you need to record when something happened or simply show the current date and time.
What an Excel timestamp means
A timestamp usually means a date and a time stored together in one cell. For example, a cell might hold the date and time an order arrived, a task was completed, or a measurement was recorded. People also use “timestamp” for a date-only or time-only entry, so it helps to decide which information you need before setting up a sheet.
Excel does not treat an ordinary date-time as a special text label. It stores it as a number and displays that number according to the cell’s number format. In the standard 1900 date system, the whole-number portion represents days and the decimal portion represents part of a day. For instance, noon is one-half of a day, or 0.5. A date with a time is therefore a single numeric value that Excel can sort, compare, calculate with, and format in different ways.
This distinction is useful: changing a cell’s appearance does not necessarily change its underlying value. A cell containing a full timestamp can be formatted to show only its date, while the time remains stored and can still affect calculations.
Insert a fixed timestamp with a keyboard shortcut
A fixed timestamp records a value that will not change just because the workbook recalculates or is reopened. In Excel for Windows, click the cell and use the following shortcuts:
Ctrl+;enters the current date.Ctrl+Shift+;enters the current time.- To put both in one cell, enter the date, type a space, and then enter the time.
The date and time are inserted as values, not as formulas. For example, if you record an arrival time at 9:15 a.m., that entry remains 9:15 a.m. later in the day. The shortcut uses the computer’s current date or time when you press it; it does not create a continuously updating clock.
In Excel for Mac, the date shortcut is generally Control+; and the time shortcut is generally Command+;. Keyboard layouts and Excel versions can affect shortcuts, so if a combination does not work, use the formula method below or check the shortcut list for your installation. Excel for the web may also handle keyboard shortcuts differently depending on the browser and operating system.
Use NOW or TODAY for a changing value
Use a formula when the cell should reflect the current date or date and time whenever Excel recalculates the workbook. With no particular cell layout required, enter =NOW() in a cell to return the current date and time. The displayed result depends on the cell’s number format. The formula is volatile: it can update during recalculation, so it is not a dependable way to preserve the moment a particular event occurred.
With no particular cell layout required, enter =TODAY() to return the current date without a time. TODAY is also recalculated, rather than being a permanent record of the date when you first typed the formula. Recalculation can happen when Excel opens or recalculates a workbook and when relevant changes are made; it is not necessarily a second-by-second clock display.
For a fixed value generated from a formula, copy the formula cell and use Home > Paste > Paste Values. This replaces the formula with its current result. On Windows, you can also use the paste-special shortcut sequence Ctrl+C, then Ctrl+Alt+V, followed by the appropriate selection for values. Check the pasted result before deleting the source formula, especially if the workbook uses linked calculations.
Format the date and time so they are readable
If a timestamp appears as a large number, the value may be correct but the cell is formatted as General or Number. Select the cell, then choose Home > Number and select a date or time format. For a more specific display, open Format Cells with Ctrl+1, choose the Number tab, select Custom, and enter a format such as yyyy-mm-dd hh:mm:ss.
That custom format displays a four-digit year, month, day, 24-hour time, minutes, and seconds—for example, 2026-11-02 14:05:09. Use h:mm AM/PM for a 12-hour clock. Formatting changes how the value looks, not the stored timestamp. If seconds are hidden, they can still be present in the underlying value.
Be careful with the letter m in custom formats. In a date section, m means month; in a time section, it means minutes. Excel interprets it from context. A format such as mm/dd/yyyy hh:mm displays month and minutes in their respective positions. For dates that may be read in different countries, a year-first format such as yyyy-mm-dd can reduce ambiguity.
Combine separate date and time cells
If a worksheet stores a date in one column and a time in another, Excel can combine them by adding their serial values. With the date in A2 and the time in B2, enter =A2+B2 in C2. If A2 contains November 2, 2026, and B2 contains 2:05 p.m., the result is November 2, 2026 at 2:05 p.m.; format C2 as a date and time to see both parts.
This method assumes that A2 and B2 contain real Excel date and time values, not text that merely looks like a date or time. If the result looks wrong, check the number formats and the underlying values. A text value imported from a file may need to be converted before Excel can add it as a date or time. Do not simply change its format and assume the text has become a usable numeric timestamp.
Record a timestamp automatically when a row changes
A common request is to stamp a row when someone enters information, then keep that time fixed. A NOW formula alone does not do this: it can recalculate and replace the apparent time with a later one. For an automatic, permanent stamp, a VBA worksheet event can write a value when a user edits a designated input column. This requires desktop Excel with macros enabled; it is not a formula and will not run in Excel for the web.
The example below watches column A and writes a timestamp in column B when a nonblank value is entered or changed. If the input in A is cleared, it clears the corresponding timestamp. In the VBA editor, place the code in the code module for the specific worksheet, not in a standard module. Save the workbook as a macro-enabled .xlsm file and ensure macros are allowed by your organization’s security settings.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim changedCells As Range
Dim cell As Range
'Only respond to edits in column A.
Set changedCells = Intersect(Target, Me.Columns("A"))
If changedCells Is Nothing Then Exit Sub
On Error GoTo CleanUp
Application.EnableEvents = False
'Stamp column B, or clear it when the input is removed.
For Each cell In changedCells.Cells
If Len(cell.Value) > 0 Then
cell.Offset(0, 1).Value = Now
cell.Offset(0, 1).NumberFormat = "yyyy-mm-dd hh:mm:ss"
Else
cell.Offset(0, 1).ClearContents
End If
Next cell
CleanUp:
Application.EnableEvents = True
End Sub
Before running or adding a macro, save a copy of the workbook. Macro changes cannot be undone with Ctrl+Z. This example also stamps again if a user edits an existing value in column A; it does not preserve the very first edit time. A different rule—such as stamping only when column B is empty—requires changing the event logic. Test the behavior on a copy with single-cell and multi-cell edits before relying on it.
Common timestamp problems and limitations
- A number appears instead of a date: Apply a date-time number format. The serial number may be the correct stored value.
- The date changes unexpectedly: Check whether the cell contains NOW or TODAY. Those formulas recalculate; keyboard-entered values do not.
- Excel will not sort dates chronologically: Some entries may be text rather than numeric date-time values. Mixed formats and imported data can cause this, so verify that Excel recognizes the entries as dates.
- The time is missing: The cell may be formatted to show only the date. Choose a format that includes hours and minutes.
- Times differ between people or systems: Excel date-time values do not include a time-zone identifier. The workbook’s displayed time is not automatically converted between time zones.
Excel’s default Windows date system is the 1900 system, while workbooks can also use the 1904 date system. The two systems assign different serial numbers to the same modern date, so copying raw date values between workbooks that use different systems can shift dates. Excel also preserves a historical compatibility quirk by treating 1900 as a leap year in its 1900 date system, even though it was not. This rarely affects current records, but it matters in calculations involving very old dates.
Excel stores date-time values as floating-point numbers, so calculations may involve tiny precision differences. For ordinary business timestamps displayed to the nearest second, this is usually not noticeable. A timestamp also has no built-in time-zone or daylight-saving metadata. If a process depends on an exact time standard across locations, record the zone or use a system designed to preserve it rather than assuming the spreadsheet value identifies a universal instant.
Frequently Asked Questions
How do I insert a timestamp in Excel without it changing?
Use Ctrl+; for a fixed date and Ctrl+Shift+; for a fixed time in Excel for Windows. Enter both in the same cell by separating them with a space. These shortcuts insert values, unlike NOW, which recalculates.
Does NOW update automatically every second?
No. NOW is a volatile formula that updates when Excel recalculates; it is not a guaranteed live clock that changes every second. Use a fixed entry or a suitable automation method when you need to preserve an event time.
Can Excel add a timestamp when I type in another cell?
Yes, but a formula by itself will not reliably preserve a permanent first-entry time. A VBA worksheet event can write a fixed value when a cell changes, provided macros are enabled and the code is placed in the correct worksheet module.
Why does my Excel timestamp show decimals or a five-digit number?
Excel stores dates and times as serial numbers. Apply a date or date-time number format to display the value as a calendar date and clock time instead of its numeric representation.
Can an Excel timestamp show my time zone?
Not as part of a standard date-time value. Excel does not attach a time-zone identifier or automatically convert the timestamp for each viewer. Include a separate zone label or use a system that stores time-zone information when that distinction matters.
Related
- Excel Data Validation Icon: What It Looks Like and Does
- Data Validation Multiple Selection in Excel: What Works
- Data Validation Interview Questions and Strong Answers
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Checkbox in Google Sheets and Use ItTo add a checkbox in Google Sheets, select the cell or range where you want it, then choose…
- How to Freeze a Group of Cells in Excel with Freeze PanesTo keep a group of rows and columns visible while you scroll in Excel, select the cell immediately…
- How to Calculate Pearson’s r in Google Sheets with CORRELTo calculate Pearson’s correlation coefficient, r, in Google Sheets, put one set of measurements in A2:A6 and the…
- Excel Data Model: Can You Turn It Off?Excel has no single switch that turns off a workbook’s Data Model. To stop a Power Query query…
- Google Sheets Conditional Formatting With IFYes. In Google Sheets, use Format > Conditional formatting, choose Custom formula is, and enter a formula that…
- Archive Emails in Outlook to a PST FileTo archive Outlook emails in a PST file, use classic Outlook for Windows: go to File > Open…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.