Apache OpenOffice Community Forum

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

See:
http://user.services.openoffice.org/en/ ... 45&t=33842

You can assign the macro SUB to a shortcout key.

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]

See Inserting the current date in Calc

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