Ask Your Question

How to write macro which evaluates =Now() and inserts result [closed]

asked 2013-09-21 09:40:47 +0100

Shane gravatar image


I often need to insert a "date / time stamp" in a cell of my calc spreadsheet as a fixed value. I can insert the formula =Now(), copy the cell, paste as a number, change the format to date / time and finally I see something like "21/09/13 09:11". There must be an easier way. How could a write a macro to achieve the same result

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-09 09:36:05.041864

1 Answer

Sort by » oldest newest most voted

answered 2013-09-21 11:15:41 +0100

JohnSUN gravatar image

What about standard hotkeys Ctrl+; and Ctrl+Shift+;? Insert Date-Time.png

edit flag offensive delete link more


Perfect, thanks

Shane gravatar imageShane ( 2013-09-21 22:14:55 +0100 )edit

Question Tools

1 follower


Asked: 2013-09-21 09:40:47 +0100

Seen: 1,605 times

Last updated: Sep 21 '13