In Excel, enter =NOW() in a cell to return the current date and time; then format that cell to choose how the result looks. For example, a custom format such as m/d/yyyy h:mm AM/PM displays a date and a 12-hour clock. NOW returns a changing value, not a permanently recorded timestamp.
What Excel’s NOW function returns
NOW is a date-and-time function. Excel stores dates as serial numbers and times as fractions of a day, so the function’s result is a numeric value even when the cell displays familiar date and time text. The whole-number portion represents the date, while the fractional portion represents the time. Formatting changes the display; it does not convert the result into a different kind of value.
To enter the function in cell A1, with no other cell references required, type =NOW() and press Enter. The cell will show the current date and time using its existing number format. If it instead shows a number such as 46,000 with decimal digits, the function may be working correctly: the cell is simply formatted as General or Number. Apply a date-and-time format to make the value readable.
The exact displayed time depends on the computer’s clock and regional settings. NOW does not include a time-zone label or independently verify the time. If the computer clock is wrong, the displayed value will be wrong too.
How to apply a date-and-time format
In Excel for Microsoft 365 on Windows, select the cell containing NOW, then use Home > Number group > Number Format to choose a built-in date or time style. The dropdown may offer date formats and time formats separately; a custom format is useful when you want both in the same cell.
- Select the cell or range that contains the NOW result.
- Open Format Cells with Ctrl+1, or use the small dialog box launcher in the Home tab’s Number group.
- Choose the Number tab, then Custom.
- Enter a format in the Type box, such as
m/d/yyyy h:mm AM/PM, and select OK.
In Excel for Mac, select the cells and open Format > Cells, then choose Custom and enter the format. Control+1 may also open Format Cells, depending on the keyboard and system settings. Excel for the web offers number-format controls on the Home tab, but the available custom-format options can differ from the desktop app; if a format is difficult to create or edit in the browser, open the workbook in desktop Excel.
Choosing a format that suits the task
Pick a format that communicates the precision readers need. A report usually does not need seconds, while a log of closely timed events may. Common examples include:
m/d/yyyy h:mm AM/PMdisplays a short date and 12-hour time, such as 11/2/2026 9:05 AM.yyyy-mm-dd hh:mmdisplays a year-first date and a 24-hour time, useful for consistent sorting and handoffs between systems.ddd, mmm d, yyyy h:mm:ss AM/PMdisplays the weekday, abbreviated month, date, and time down to seconds.h:mm AM/PMdisplays only the time of day. The date remains part of the value even though it is hidden.
In these examples, lowercase m means month when used with a date, but in a time section such as h:mm, it means minutes. This context-sensitive behavior can cause confusing results if a custom format is assembled without separators. Use a ready-made format as a starting point and check the preview in Format Cells.
Regional settings also matter. A format using m/d/yyyy may be read differently from d/m/yyyy by people in different countries. A year-first format such as yyyy-mm-dd avoids that particular ambiguity, although the workbook’s regional settings may affect how dates are interpreted when entered.
Custom formats and display details
A custom number format can combine date and time components in one cell. In a format such as ddd, mmm d, yyyy h:mm AM/PM, the commas and spaces are displayed as separators, while the letter codes tell Excel which parts of the stored value to show. Use hh for a two-digit hour and ss for seconds. Use AM/PM for a 12-hour clock; omit it for a 24-hour clock.
Changing the format does not change the underlying timestamp. You can verify this by selecting the cell and looking at the formula bar: the formula remains NOW, and the cell’s numeric value can still be used in date-and-time calculations. For instance, two date-time values can be subtracted to calculate elapsed time, though the result’s own cell format may need changing to show a duration rather than a calendar date.
If you see hash marks instead of a date, Excel may not have enough column width to display the selected format. Widen the column or choose a shorter format. If you see only a date, choose a format that includes an hour component; if you see only a time, choose one that includes the date.
Why the NOW result changes
NOW is volatile: Excel recalculates it when the workbook recalculates. In the usual Automatic calculation mode, that can happen when a value changes, when the workbook is opened, or when Excel otherwise recalculates the sheet. It does not normally update continuously like a running clock, and it is not a reliable way to display a timer that refreshes every second.
To check the calculation setting in Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. If calculation is set to Manual, NOW may remain unchanged until a recalculation is triggered. Pressing F9 recalculates open workbooks; Ctrl+Alt+F9 forces a full recalculation. Recalculation can update other formulas too, so check dependent cells if a result changes unexpectedly.
Excel may also recalculate when you open a workbook on another computer, depending on its calculation settings. This is one reason a NOW value should not be mistaken for an audit record. Formatting it with seconds does not make it permanent or guarantee that Excel captured the exact moment an event occurred.
When you need a fixed timestamp
If you want the time an entry was made to stay fixed, NOW is usually the wrong tool by itself. Because it recalculates, the displayed time can move later. Instead, insert a static date and time as a value, or use a carefully designed workflow that records the time once. In a manually maintained log, enter the date and time as values and apply a date-time format; those entries will not change just because the workbook recalculates.
Another option is to copy a NOW result and use Paste Special > Values to replace the formula with its current value. Do this only when you intend to freeze that timestamp: after pasting values, the cell no longer contains a live NOW formula. For frequent data entry, consider whether a form, an approved macro, or a database-backed process is more appropriate. A formula that recalculates is not a substitute for a controlled, tamper-resistant record.
A related function, TODAY, returns the current date without a time component. With the function entered in a cell, a date-only format is generally appropriate. Like NOW, TODAY recalculates; it is not a permanent record of the date on which a row was first created.
Common problems and misconceptions
- The cell shows a large number: apply a date-and-time format. Excel stores dates and times numerically.
- The time seems frozen: check Formulas > Calculation Options and confirm that calculation is Automatic, or trigger recalculation.
- The time changes after an edit: this is expected behavior for a volatile function. Use a static value when the timestamp must stay fixed.
- The time is off by hours: check the computer’s clock and time-zone settings. NOW uses the system’s local time; it does not automatically convert between time zones.
- The seconds do not change visibly: NOW is not a live clock. Formatting to show seconds only changes precision of the display, not the recalculation frequency.
Also distinguish a number format from text. A format changes how Excel displays a numeric date-time value while preserving its ability to participate in calculations. Converting a result to text, by contrast, can make date arithmetic and sorting less dependable. If a report needs readable dates and later calculations, keep the values numeric and apply an appropriate format.
Frequently Asked Questions
What is the correct Excel NOW formula?
Enter =NOW() in a cell. It has no arguments and returns the current date and time according to the computer’s clock when Excel recalculates.
How do I show only the time from NOW?
Keep the NOW formula, select its cell, and apply a time format such as h:mm AM/PM. The date remains in the stored value but is hidden by the format.
Can Excel NOW update every second?
Not as a continuously running clock under normal recalculation. NOW updates when Excel recalculates the workbook or formula, so it should not be used as a second-by-second timer.
How do I stop NOW from changing?
Replace the formula with a fixed value, for example by copying the cell and using Paste Special > Values. Once replaced, the cell will no longer update automatically.
What is the difference between NOW and TODAY?
NOW returns a date and time; TODAY returns the current date without a time component. Both are recalculated functions, so neither automatically records an unchanging entry date.
Related
- Excel Not Responding? Causes, Fixes, and Recovery Steps
- Excel Slow? Causes, Fixes, and Ways to Speed It Up
- Cash Flow Excel Sheet: Build a Reliable Monthly Forecast
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Flash Fill vs AutoFill in Excel: What’s Different?Flash Fill recognizes a pattern in example data and fills in similar text, while AutoFill copies cells or…
- Can You Split a Cell in Excel With Two Colors at Once?No—not as two independently filled halves of one cell. Excel gives a cell one overall fill color, but…
- Excel Keyboard Shortcut to Delete a Column SafelyIn Excel for Microsoft 365 on Windows, select any cell in the column and press Ctrl+Space, then press…
- Excel Text Equals: How to Compare Text Values in CellsIn Excel, use the equals sign in a formula to check whether two text values match: with the…
- Excel Import CSV: Does the First Row Become Headers?When you open a CSV file directly in Excel, its first row appears in row 1, but Excel…
- How to Clear the Offline Cache in OutlookTo clear Outlook’s offline cache in classic Outlook for Windows, close Outlook, find the account’s .ost file, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.