Write a full appointment date and time
Turn 11/4/2026 2:30 PM into the text November 4, 2026 at 2:30 PM for a letter.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The real appointment date and time. | 11/4/2026 2:30 PM |
| 2 | "mmmm d, yyyy | Writes the month name, day and year. | "November 4, 2026" |
| 3 | ""at"" | Adds the word at. | "November 4, 2026 at" |
| 4 | h:mm AM/PM" | Adds the hour, minutes and AM or PM. | "… 2026 at 2:30 PM" |
| 5 | TEXT( … ) | Writes the date and time in that pattern as text. | "… 2026 at 2:30 PM" |
Parts 2 to 4 are one pattern. The doubled quotes keep at as a plain word.
=TEXT(A8,"mmmm d, yyyy ""at"" h:mm AM/PM")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own dates and times. Paste real dates and times into the green column of the Template tab. The letter text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Seconds and time zone are left off. Check the times are in the reader's own time zone.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Write a timestamp caption that says UTC
11/4/2026 2:30 PM → Nov 4, 2026 2:30 PM UTC
Get the template →
Create a timestamp filename label
November 4, 2026 2:30:15 PM → 20261104_143015
Get the template →
Export a timestamp with no time zone
November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →