You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by paulranger <ra...@southernphone.com.au> on 2017/04/12 08:07:40 UTC
Cannot get cells to accept "Date" formatting.
Hello all,
I am running AOO 4.1.3 on iMac Yosemite 10.10.5. I keep several spreadsheets which detail orders, symbol keys etc. but cannot format cells to accept ‘Format/Cells…/Date’ with "31 Dec 1999” option.
When I press the keys “3”, “/“, “4” and “return”, the tabulation “3/4” (superscript subscript) as a fraction is displayed, not the desired date 3 April 2017. I have tried copying a formatted cell (above the blank cell) which is correctly formatted e.g. “17 Mar 2017” and pasted that into the cell I want to fill, assuming that the correct formatting of the ‘copy’ cell will transfer to the desired cell through the subsequent ‘paste’ action. Alas, the ‘3 / 4’ key entry still displays as a fraction, not a date.
Could someone please advise how I can achieve the Date formatting I need?
Sincerely, ranger1s.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Cannot get cells to accept "Date" formatting.
Posted by paulranger <ra...@southernphone.com.au>.
Thank you, Martin. I followed your kind advice and the cell Date formatting seems to be resolved.
Sincerely, ranger1.
> On 12 Apr 2017, at 6:31 pm, Martin Groenescheij <Ma...@Groenescheij.COM> wrote:
>
>
>
> On 12/04/17 6:07 PM, paulranger wrote:
>> Hello all,
>>
>> I am running AOO 4.1.3 on iMac Yosemite 10.10.5. I keep several spreadsheets which detail orders, symbol keys etc. but cannot format cells to accept ‘Format/Cells…/Date’ with "31 Dec 1999” option.
>>
>> When I press the keys “3”, “/“, “4” and “return”, the tabulation “3/4” (superscript subscript) as a fraction is displayed, not the desired date 3 April 2017. I have tried copying a formatted cell (above the blank cell) which is correctly formatted e.g. “17 Mar 2017” and pasted that into the cell I want to fill, assuming that the correct formatting of the ‘copy’ cell will transfer to the desired cell through the subsequent ‘paste’ action. Alas, the ‘3 / 4’ key entry still displays as a fraction, not a date.
>>
>> Could someone please advise how I can achieve the Date formatting I need?
>
> Under Tools (Preference) go to AutoCorrect Options go to the Options Tab and deselect the "Use replacement table" box
>
>>
>> Sincerely, ranger1s.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Cannot get cells to accept "Date" formatting.
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 12/04/17 6:07 PM, paulranger wrote:
> Hello all,
>
> I am running AOO 4.1.3 on iMac Yosemite 10.10.5. I keep several spreadsheets which detail orders, symbol keys etc. but cannot format cells to accept ‘Format/Cells…/Date’ with "31 Dec 1999” option.
>
> When I press the keys “3”, “/“, “4” and “return”, the tabulation “3/4” (superscript subscript) as a fraction is displayed, not the desired date 3 April 2017. I have tried copying a formatted cell (above the blank cell) which is correctly formatted e.g. “17 Mar 2017” and pasted that into the cell I want to fill, assuming that the correct formatting of the ‘copy’ cell will transfer to the desired cell through the subsequent ‘paste’ action. Alas, the ‘3 / 4’ key entry still displays as a fraction, not a date.
>
> Could someone please advise how I can achieve the Date formatting I need?
Under Tools (Preference) go to AutoCorrect Options go to the Options Tab
and deselect the "Use replacement table" box
>
> Sincerely, ranger1s.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org