Ask Your Question
0

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

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

Shane gravatar image

Hi,

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
1

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

JohnSUN gravatar image

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

edit flag offensive delete link more

Comments

Perfect, thanks

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

Question Tools

1 follower

Stats

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

Seen: 1,615 times

Last updated: Sep 21 '13