Write a timestamp caption that says UTC

Turn the UTC time 11/4/2026 2:30 PM into the caption Nov 4, 2026 2:30 PM UTC.

What you'll make

In Excel: 11/4/2026 2:30 PM becomes Nov 4, 2026 2:30 PM UTC.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The real date and time, already in UTC.11/4/2026 2:30 PM
2"mmm d, yyyy h:mm AM/PM"The pattern: short month, day, year, then the time."mmm d, yyyy h:mm AM/PM"
3TEXT( … )Writes the date and time in that pattern as text."Nov 4, 2026 2:30 PM"
4&" UTC"Adds a space and UTC to the end."Nov 4, 2026 2:30 PM UTC"

UTC only labels the time; it doesn't convert it. The month names come out in English.

=TEXT(A8,"mmm d, yyyy h:mm AM/PM")&" UTC"

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own dates and times. Paste real UTC dates and times into the green column of the Template tab. The captions fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check your times are already in UTC. Adding UTC labels them; it doesn't convert local times.

Microsoft's help: TEXT function