View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default All Excel Dates show as 2006

On Tue, 19 Sep 2006 11:56:01 -0700, Millie
wrote:

March 2003, April 2004, January 2005, etc.

"Ron Rosenfeld" wrote:

On Tue, 19 Sep 2006 11:39:01 -0700, Millie
wrote:

All my dates are showing as 2006. Even when I type 2003 or 2004, they come in
as 2006. What is causing this problem?


What are you typing when you try to enter a date?
--ron


I assume you are typing the above into a cell. After you do that, what shows
in the Formula Bar?
--ron