ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   00-jan-00 (https://www.excelbanter.com/excel-worksheet-functions/5828-00-jan-00-a.html)

Gail

00-jan-00
 
Sometimes and only some worksheets even within the same workbook??? trying to
enter dates and get this result. checked tools ; Options confirmed using
1900 NOT 1904. don't recall ever mucking around with that. This issue first
started after Y2K changeover. Had a KB article on it at one time but can't
find it now. A search on the Microsoft KB produces nothing. This is driving
me crazy and that's not far to go. Can anyone tell me how to clear this up
once and for all????
--
Thank you for your help
Gail


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com