Create a timestamp filename label
Turn November 4, 2026 2:30:15 PM into 20261104_143015, with no slashes or colons.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The real date and time. | November 4, 2026 2:30:15 PM |
| 2 | "yyyymmdd | Writes the date as year, month, day with no gaps. | "20261104" |
| 3 | ""_"" | Adds an underscore between date and time. | "20261104_" |
| 4 | hhmmss" | Adds the time: hours 00 to 23, minutes, seconds. | "20261104_143015" |
| 5 | TEXT( … ) | Writes the date and time in that pattern as text. | "20261104_143015" |
Parts 2 to 4 are one pattern. The doubled quotes keep the underscore as a plain mark.
=TEXT(A8,"yyyymmdd""_""hhmmss")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 labels fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Two times in the same second get the same label. Add something extra if each name must differ.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Export a timestamp with no time zone
November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15
Get the template →
Export a UTC timestamp with a Z suffix
November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15Z
Get the template →
Export a timestamp with milliseconds
11/4/2026 2:30:15.123 PM → 2026-11-04T14:30:15.123
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →