Am 09.09.2012 12:19, IGraham wrote:
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
There is no "date type" in a spreadsheet. You can leave it up to the user.
Any of:
2012/9/13
2012-9-13
13 sep
sep 13
13/
and many other input methods yields the exact same date of current
month's 13th (which is unformatted day number 41165 in September 2012).
Your suggestion "01/01/2012" is ambiguous anyway because it is unclear
if "01/02/2012" refers to the 2nd of January (USA) or 1st of February
(other planet).
--
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
