Thanks Brian. With a little finagling, I got this to work!
Brian Barker wrote > 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: > [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 -- View this message in context: http://nabble.documentfoundation.org/Changing-time-format-in-Calc-header-tp4027848p4028065.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions 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
