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