Excel NOW as Text: Show the Current Date and Time

How-to basics · Updated November 18, 2026

Excel’s NOW() function returns the current date and time as a date-time value, not as text. To turn that result into text, use TEXT, for example =TEXT(NOW(),"yyyy-mm-dd hh:mm:ss"); to keep a usable date-time value and only change how it looks, format the cell instead.

What Excel’s NOW function returns

NOW() gives Excel a date-and-time value that it can display, compare, sort, and use in calculations. Although it may look like a string on the worksheet, the underlying value is numeric: the date is represented by a serial number, and the time is represented by a fraction of a day. For example, a time of noon is one-half of a day.

That distinction explains why two cells can look identical but behave differently. A cell containing a real date-time value can be used to calculate elapsed time or filter a range chronologically. Text that merely looks like a date may not work as expected in those operations. Excel’s date system also has compatibility details, so a serial number copied between programs is not necessarily meaningful on its own; use a displayed date or an appropriate date-time format when people need to read it.

With the destination cell selected, enter =NOW() and press Enter. Excel displays the result using the cell’s current number format. If the cell is formatted as General, the appearance may include a date and time or a number, depending on the column width and Excel settings. The formula itself remains a date-time value.

Display NOW as text or just change its appearance?

Use a number format when the value should remain a date-time for calculations. Formatting changes the display, not the stored value. For example, the cell can show only the date while still retaining its time internally. This is usually the better choice for logs, calculations, sorting, and charts.

Use TEXT when the result must be text, such as when joining the date and time into a sentence or building a label. The trade-off is that a text result is no longer a numeric date-time. It cannot directly serve as a date in calculations, and sorting text dates can produce a different order from sorting actual dates.

  • Keep it numeric: use =NOW() and apply a date-time number format.
  • Convert it to text: use TEXT with a format code, then use the result where text is needed.
  • Keep a fixed timestamp: insert or paste a value rather than leaving a live NOW() formula.

Format NOW as readable text with TEXT

The TEXT function takes a value and a format code, then returns a text string showing that value in the requested style. In the example below, the formula is entered directly in the cell where the text should appear; it returns a date and time in year-month-day order, followed by hours, minutes, and seconds.

With the formula entered in the output cell, use =TEXT(NOW(),"yyyy-mm-dd hh:mm:ss"). For example, if Excel evaluates the formula at 3:07:09 PM on 2 November 2026, the displayed text is 2026-11-02 15:07:09. The exact result depends on the moment Excel recalculates it.

To make a more conversational label, first put =NOW() in A1. Then, with A1 containing that date-time value and the text formula in another cell, use =TEXT(A1,"dddd, mmmm d, yyyy h:mm AM/PM"). The result might read Monday, November 2, 2026 3:07 PM. The day name in the example depends on the date; the format code tells Excel to show a full weekday, full month, day, year, and 12-hour time.

Common format-code parts include yyyy for a four-digit year, mm for a two-digit month when used in a date, dd for a two-digit day, hh for a two-digit hour, and ss for seconds. In a time pattern such as hh:mm:ss, the middle mm represents minutes. Use AM/PM for a 12-hour clock; omit it for a 24-hour style. The result is text, so Excel does not automatically keep it as a date just because it looks like one.

Apply a date-time format without converting the value

If you want a cleaner display but need to retain the date-time for calculations, leave the formula as =NOW() and change the cell’s number format. Select the cell, open Format Cells with Ctrl+1 on Windows, choose the Number tab, and select Date, Time, or Custom. In Custom, enter a pattern such as yyyy-mm-dd hh:mm:ss, then confirm. The value remains numeric.

A custom format can hide parts of the value without deleting them. If a cell displays only a date, for instance, its stored value may still include the time. Refer to the value in a calculation before assuming that the displayed precision is the full precision. On Mac, the Format Cells dialog is also available, though keyboard shortcuts can differ with the keyboard layout and Excel version; use the dialog if the Windows shortcut does not work.

Formatting codes and their displayed month or day names can be affected by Excel’s regional and language settings. A pattern with slashes may appear differently in another locale, and month or weekday names may be localized. A year-first pattern such as yyyy-mm-dd is often easier to interpret across regions, but it does not make a text result numeric.

Why NOW changes and how to keep a fixed timestamp

NOW() is a volatile function: Excel recalculates it when the workbook recalculates, rather than preserving the time when the formula was first entered. It may update after edits, opening the workbook, or a recalculation. It is not a continuously running clock that refreshes every second. The precise recalculation behavior depends on workbook calculation settings and what prompts recalculation.

This makes NOW() useful for showing a current time, but unsuitable by itself as an audit timestamp for when a record was first created. If every row uses a live formula, older rows can appear to have the same current time after recalculation. For a one-time timestamp, insert a static value or copy the formula result and paste it as a value.

To freeze a formula result, copy the cell, then choose Home > Paste > Paste Values. The result stays in the workbook as a value rather than a live formula. If the cell was converted with TEXT, the pasted result remains text; if the original cell contained =NOW(), the pasted result is a numeric date-time value. Keep a backup or verify the result before replacing formulas in a working range.

Common problems when NOW appears as text

A frequent surprise is that Excel shows the formula itself, such as =NOW(), rather than calculating it. One cause is that the cell was set to the Text format before the formula was entered. Change the format to General, then edit and re-enter the formula. A leading apostrophe can also tell Excel to treat an entry as text; remove it if the cell should calculate a formula.

If a cell shows a row of number signs, the date-time may be valid but the column may be too narrow. Widen the column or choose a shorter number format. If the time looks absent, check whether the selected format displays only the date. If it updates unexpectedly, check whether the formula is still live and whether the workbook recalculates.

If TEXT returns an unexpected-looking date, inspect the format code and the workbook’s regional settings. Also check that the referenced cell really contains a date-time value rather than text already imported from another source. Formatting text with TEXT does not reliably convert arbitrary text into a valid date; first convert or clean the source data using an appropriate method.

Choosing the right method for a workbook

The right approach depends on what the next user or formula needs to do with the result. Use a live numeric value if it will be used in calculations; use text if the output is being assembled into a message or exported as a label; use a fixed value if the timestamp must not change later.

  • Timesheet or elapsed-time calculation: keep date-time values numeric and use cell formatting for readability.
  • Report heading: use TEXT when the date needs to appear inside a text string.
  • Record creation time: use a fixed timestamp, not a volatile formula that can change.
  • Data exchange: confirm whether the receiving system expects date-time values or text, and agree on an unambiguous format.

For example, a report heading can combine words with a formatted date. With NOW evaluated directly inside the label formula, use ="Report updated "&TEXT(NOW(),"mmm d, yyyy h:mm AM/PM"). This produces a text sentence, not a date-time value. If another calculation later needs the time, keep a separate numeric cell containing =NOW() rather than trying to calculate from the finished sentence.

Frequently Asked Questions

Does Excel NOW return text?
No. NOW() returns a numeric date-time value. Excel may display that value in a human-readable date and time format, but the display does not make the underlying value text.

How do I convert NOW to text in Excel?
Use TEXT with a format code, such as =TEXT(NOW(),"yyyy-mm-dd hh:mm:ss"). The result is text and will not behave like a normal numeric date-time in calculations.

How can I show only the date from NOW?
Keep the NOW() value and apply a date-only number format if you need calculations. Use TEXT with a date-only pattern, such as =TEXT(NOW(),"yyyy-mm-dd"), only when you specifically need text.

Why does my NOW formula keep changing?
NOW() is volatile and updates when Excel recalculates the workbook. To retain a particular time, replace the formula with its value, for example by copying the cell and using Paste Values.

Can I use NOW as a permanent entry time for each row?
Not as a live formula: recalculation can change its result. Use a fixed timestamp entered or pasted as a value for a permanent record, and consider whether the workbook’s users need a controlled process for recording it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.