Hi - If I use today() on its own the date is for example shown (in UK) as 10 November 2023. However when I combine
"Printed "&today()
it is displayed as
Printed 10/11/2023.
To include the word "Printed" with my preferred formatting I am currently entering:
"Printed "&DAY(TODAY())&" "&LEFT(MONTHNAME(MONTH(TODAY())),3)&" "&YEAR(TODAY())
The result I am trying to get is
Printed 10 Nov 2023
Is there an easier way? Thanks
MacBook Air 13″, macOS 13.4
You could use a custom format, then all the cell has to contain is the date itself.
Hi Stephen,
If you want to place a Date & Time in the Page Header or Page Footer of a Numbers Sheet, do Menu > File > Print (command P) to see Print Setup.
Hover the cursor over a page in Print Setup to see the Headers and Footers.
Click in any field of a Header or Footer.
Type "Printed "
Menu > Insert > Date & Time
Click on the Date & Time to change the display
Happy Numbering!
Ian.
Absolutely perfect, so many thanks. I have never ventured into custom formats before but will now explore them more thoroughly, again thanks. Stephen
Stephen,
did any of the posts in this thread solve you question? Marking the post that can be helpful to others who read the post
numbers date format combined with text
