At 15:13 04/02/2015 -0500, Vince Bonly wrote:
On Feb 4, 2015, at 13:55, Brian Barker wrote:
From: Vince Bonly:
Date: Wed, 04 Feb 2015 11:51:53 -0500
Does a feature exist whereby I can insert Today's Date into a Calc cell?
Try:
o Enter =NOW()
o F2; F9; Enter; Enter.
After formatting the cells to Date (MMM D, YYYY) your suggestion of
=NOW()
Worked splendidly; thanks!
By itself, that won't do what you need. It creates a formula whose
value is the date (and possibly time) when the cell contents were
last calculated. If you enter it today you will see today's date, but
if you save the spreadsheet and reopen it next week you will see
*that* day's date, not the original date that I take it you want.
There are various ways to freeze the result of the formula so that it
becomes a value and will not change on future dates, and the sequence
F2, F9, Enter, Enter is one of them. Another is to copy the cell
contents back over themselves using Paste Special... with Formulas unticked.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
