On 27/07/16 15:13, Brian Barker wrote:
At 07:23 27/07/2016 -0400, William Drescher wrote:
I have version Version: 5.0.5.2
In writer I can insert a field that shows the current date whenever
the document is opened. I can't figure out how to do that in a
spreadsheet. Help please.
As has already been noted, you can add date and time to the header or
footer at Format | Page... | Header (or Footer) | Edit... .
If you want to put the date into a cell, use the formula
=TODAY()
- which returns the current date. You can format the cell to display the
date in your chosen format, of course.
Alternatively,
=NOW()
returns the current date and time.
I trust this helps.
Brian Barker
You can also double-click to edit the cell, then R-click on it and
select 'Insert Fields...', which offers a small submenu of Date, Sheet
Name, and Title. Not that I've found a way of then specifying the date
format :-{
Is there any (good) reason Calc doesn't have the same "Insert|Field"
menu as Writer? I do dislike inconsistencies like this.
--
Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
