Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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