Re: [libreoffice-users] calc - message in cell

Hi,

IGraham schrieb:
> Calc
> How do i (can i) place in a cell a message - that isn't part of the active
> spreadsheet
> I want to tell the user the data type they should be entering as 'date type
> 01/01/2012' and that the message will disappears as the user starts typing
> Thanks for any help

Go to the cell.
In menu Data > Validity.
In tab Input Help enter Title and help text.
Check "Show input help when cell is selected."

You shoud not use 01/01/2012 as example, because it is not clear, which 
01 is the day and which the month. If you want an example, use a day 
which is impossible as month e.g. 31/12/2012 or use the more general 
form dd/mm/yyyy.

Kind regards
Regina


--
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