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 <du...@austin.rr.com> 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] --
