<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Set Default Year for data entry with options"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131020#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Set Default Year for data entry with options"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131020">bug 131020</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>If you don't need to calculate with a date then preceding an incomplete input
with an ' apostrophe would force the input to text content, like
'13/5
(or en-US)
'5/13
Assigning a number format of
@"/19"
then would display that as
13/5/19
or
5/13/19
If you pre-format the cells with such text format
@"/19"
before input then you don't even need to (and must not) input the leading '
apostrophe.
As said, this works only if you don't need to calculate with such "date".</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>