Actually, what I need is "current date" whenever I reopen the
spreadsheet. This will save me time and avoid typos, since I have fat
fingers and poor vision! I do not need a time stamp included for my Oil
Consumption calculations.
I do not understand about the "F2, F9,Enter,Enter" sequence (is that a
separate/alternative sequence, or required with the =NOW()?); it does
not work here (using AOO4.1.1, Spreadsheet) when I tried that
suggestion. Maybe I need to preprogram the Function keys; I have not
done that, as yet.
On 2/4/2015 3:31 PM, Brian Barker wrote:
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
