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
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