[Solved] Calc - Insert Date

Discuss the spreadsheet application
Post Reply
Essex Lad
Posts: 2
Joined: Sun Nov 22, 2009 6:02 pm

[Solved] Calc - Insert Date

Post by Essex Lad »

I am new to Open Office - Is there a short cut for entering the current date into a cell?

I would be grateful for any help :bravo:
Last edited by Essex Lad on Sun Nov 22, 2009 7:52 pm, edited 1 time in total.
Open Office 3.1
Vista sp2
User avatar
Villeroy
Volunteer
Posts: 30874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc - Insert Date

Post by Villeroy »

Easiest: Remember today's day number (22) and type it with "/" appended: Type 22/
Easy: Type =today() F9 Enter Enter
Complex: Install my little macro suite and assign a shortcut to macro "NowToActiveCell": http://user.services.openoffice.org/en/ ... 21&t=12575
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
Essex Lad
Posts: 2
Joined: Sun Nov 22, 2009 6:02 pm

Re: Calc - Insert Date

Post by Essex Lad »

Thanks very for your help :D
Open Office 3.1
Vista sp2
Post Reply