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/
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
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
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 Dua
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 t
