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
|