Re: Date Format error in Spreadsheet
When using dates if you present it like 1-15, it will show as 1/15/2024 if you have it formatted as date! Sent from Fritz Lipske On Jan 16, 2024, at 2:05 AM, David wrote: Duane wrote: > Cell formatted for date in form 12/31/99 reads as the fraction, 1/2 when the > date is specified as 1/2/2024. I have the latest version of installed. The > same problem existed with the down level version. Let me know if this is a > bug or if I am doing something wrong. All other dates seem to work as they > should. > Thank you for your help and consideration. > Duane Weber > du...@austin.rr.com > [1d73218c-758c-45c9-a2cc-ef10f108762a] You may have Use replacement table activated under Tools | Autocorrect Options. By default this will correct 1/2 to the fraction ½ If you don't want automatic correction, turn it off; alternatively you can remove the correction from the replacement table and continue to have autocorrection. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mailing-lists.html As a courtesy I have forwarded a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at - replies to my personal email address will be ignored. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Date Format error in Spreadsheet
Duane wrote: Cell formatted for date in form 12/31/99 reads as the fraction, 1/2 when the date is specified as 1/2/2024. I have the latest version of installed. The same problem existed with the down level version. Let me know if this is a bug or if I am doing something wrong. All other dates seem to work as they should. Thank you for your help and consideration. Duane Weber du...@austin.rr.com [1d73218c-758c-45c9-a2cc-ef10f108762a] You may have Use replacement table activated under Tools | Autocorrect Options. By default this will correct 1/2 to the fraction ½ If you don't want automatic correction, turn it off; alternatively you can remove the correction from the replacement table and continue to have autocorrection. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mailing-lists.html As a courtesy I have forwarded a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at - replies to my personal email address will be ignored. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Date Format error in Spreadsheet
I use a Hyphen rather than a forward slash. Alan,Lurking near Bristol UK.Sent from my Galaxy Original message From: dk...@tuta.io.INVALID Date: 16/01/2024 00:30 (GMT+00:00) To: Users Subject: Re: Date Format error in Spreadsheet It sees 1/2 as one-half. Type 01/2 and it should work OK.-- Sent with Tuta; enjoy secure & ad-free emails: https://tuta.comJan 15, 2024, 17:35 by du...@austin.rr.com:> Cell formatted for date in form 12/31/99 reads as the fraction, 1/2 when the date is specified as 1/2/2024. I have the latest version of installed. The same problem existed with the down level version. Let me know if this is a bug or if I am doing something wrong. All other dates seem to work as they should.> Thank you for your help and consideration.> Duane Weber> du...@austin.rr.com> [1d73218c-758c-45c9-a2cc-ef10f108762a]>
Re: Date Format error in Spreadsheet
Ctrl+Z at the right time also creates the entry as a date. Type "1/2/". When the 2nd "/" is typed the 1/2 becomes ½. Immediately type Ctrl+Z and ½ reverts back to 1/2. Now type /2024 and complete the cell entry. The date will be correctly entered as "1/2/2024". On Mon, Jan 15, 2024 at 6:35 PM Duane wrote: > Cell formatted for date in form 12/31/99 reads as the fraction, 1/2 when > the date is specified as 1/2/2024. I have the latest version of > installed. The same problem existed with the down level version. Let me > know if this is a bug or if I am doing something wrong. All other dates > seem to work as they should. > Thank you for your help and consideration. > Duane Weber > du...@austin.rr.com > [1d73218c-758c-45c9-a2cc-ef10f108762a] --
Re: Date Format error in Spreadsheet
It sees 1/2 as one-half. Type 01/2 and it should work OK. -- Sent with Tuta; enjoy secure & ad-free emails: https://tuta.com Jan 15, 2024, 17:35 by du...@austin.rr.com: > Cell formatted for date in form 12/31/99 reads as the fraction, 1/2 when the > date is specified as 1/2/2024. I have the latest version of installed. The > same problem existed with the down level version. Let me know if this is a > bug or if I am doing something wrong. All other dates seem to work as they > should. > Thank you for your help and consideration. > Duane Weber > du...@austin.rr.com > [1d73218c-758c-45c9-a2cc-ef10f108762a] >
