Re: [libreoffice-users] Changing time format in Calc header

At 12:15 08/01/2013 -0800, Karen Dinse wrote:
> We are using Windows XP, SP3, LibreOffice 3.5.5.3
>
> We have created a Calc spreadsheet and want to show the time in the 
> header. When we print the sheet, the time shows military time.  Is 
> there a way to change that to show 12 hour time?  I know that we 
> would have to enter am or pm if needed.

Not that I know of - but there may be a workaround.  You can arrange 
for a row or rows of a Calc spreadsheet to be repeated on every page 
of the printout.

o In a suitable cell in a low-numbered row, enter =NOW()
o Format that cell suitably - perhaps as H:MM AM/PM
o Go to Format | Print Ranges > | Edit... .
o Under "Rows to repeat", click the Shrink button at the right.
o Click a cell in the required row or drag across cells in the required rows.
o Click the Shrink button again and then click OK.

You will need to update the time before you print on each 
occasion.  To do this, go to Tools | Cell Contents > | Recalculate 
(or just press F9).

I trust this helps.

Brian Barker



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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