Hi,
When I insert the Date & Time in a cell, it only puts in the Long Date (Friday, December 15, 2017). How do I make it add the short date (12/15/2017)? I have set the default to the entire column to the short date but the Insert command still adds the Long Date.
Thanks for the help.
macOS High Sierra (10.13.2)
When inserting date-time I use this 'Today' Automator Service (Dropbox download). It doesn't require a double-click in the cell and seems to respect cell formatting better. For example it works well with cells you have formatted as dd/mm/yyyy.
To install double-click downloaded .workflow package and give permission at System Preferences > Security & Privacy. System Preferences > Security & Privacy. Also make sure 'Automator.app' is checked at System Preferences > Security & Privacy > Privacy > Accessibility.
Thereafter to use just choose Today from the Numbers > Services menu. Or you can attach a keyboard shortcut.
SG
When inserting date-time I use this 'Today' Automator Service (Dropbox download). It doesn't require a double-click in the cell and seems to respect cell formatting better. For example it works well with cells you have formatted as dd/mm/yyyy.
To install double-click downloaded .workflow package and give permission at System Preferences > Security & Privacy. System Preferences > Security & Privacy. Also make sure 'Automator.app' is checked at System Preferences > Security & Privacy > Privacy > Accessibility.
Thereafter to use just choose Today from the Numbers > Services menu. Or you can attach a keyboard shortcut.
SG
You are right indeed.
If you take it one click further — after the date has been inserted — you can change the format out of the suggested formats.
"Insert —> Date & Time" has its own procedure apparently.
If you do not like this procedure you might consider preformatting the cells with the desired format and then filling in the dates. I know this works.
Paul.
Apparently the Full date format from System Preferences:
Paul.
Hi Mah,
SG's 'Today' Automator Service is excellent.
But back to your original question:
Please reply and tell us what is not working for you.
Regards,
Ian.
"Insert —> Date & Time" does not work any longer (greyed out???) in a new sheet I just opened.
Seems a bug to me in the software somewhere.
My guess, you better provide feedback to Apple.
Paul.
It’s greyed out if the cell is selected, but if you click in the cell so the cursor is flashing then it’s not greyed.
I did format the cell prior to 12/12/2017, but Insert->Date & Time only inserts December 12, 2017. Wasn’t sure if it’s getting that from Numbers or from the OS somewhere.
Ya, I messed with that too changing the Full format to the Short. Didn’t fix. Must just be a shortfall of Numbers.
You just wrote:
"Didn’t fix."
Well, fix it. What else is there to say.
Paul.
SG, thanks for this 'Today' Automator Service. Paul.
Thanks SG...This is perfect.
Date & Time
