I recall that Exc*ll had a keyboard shortcut for inserting today's date in a cell but I can't find out how you do this in OO.
All help welcomed,
Bob
Insert today's date
Insert today's date
OOo 3.2.1 on Ms Windows XP
Re: Insert today's date
See:
http://user.services.openoffice.org/en/ ... 45&t=33842
You can assign the macro SUB to a shortcout key.
http://user.services.openoffice.org/en/ ... 45&t=33842
You can assign the macro SUB to a shortcout key.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Insert today's date
Insert>Names>Define...
Name: T [or any other letter]
Refers to: TODAY()
[Add]
[OK]
On the sheet you perform the following keystrokes:
=N [F9] [Enter] [Enter]
Name: T [or any other letter]
Refers to: TODAY()
[Add]
[OK]
On the sheet you perform the following keystrokes:
=N [F9] [Enter] [Enter]
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- MrProgrammer
- Moderator
- Posts: 4905
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Insert today's date
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Insert today's date
Thanks for all that. I best liked the idea of typing the day followed by / that I saw somewhere else. But they're all pretty clunky so I can't really call it solved. I wonder why such a simple thing is missing.
Thanks anyway,
Bob
Thanks anyway,
Bob
OOo 3.2.1 on Ms Windows XP