Help with formatting the date.
 

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

Help with formatting the date.
 

Go to Tools-- options and select Calcualtion tab.
Take out 1904 date system in workgruop options and click ok.
As simple as that.
Natraj

"Lee" wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

Help with formatting the date.
 

Natra, That was unchecked already. With it check the program thinks it's
2008. It thinks the year is 2004 without it checked. Could it be that the
reason is that the original date I created the worksheet was in 2004 and it
will not let me modify it now?
--
Lee Davenport


"Natraj" wrote:

Go to Tools-- options and select Calcualtion tab.
Take out 1904 date system in workgruop options and click ok.
As simple as that.
Natraj

"Lee" wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

Help with formatting the date.
 

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson

Help with formatting the date.
 

Dave, That did not work. Under the View Code tab, there is nothing written in
the box. I have found that it works like I want if I take a new worksheet and
apply the date formatting to a cell, just not on the worksheet that I had
originally created in 2004.
--
Lee Davenport


"Dave Peterson" wrote:

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson

Help with formatting the date.
 

You did try the safe mode test, too?

I don't have any other guesses.

Sorry.

Lee wrote:

Dave, That did not work. Under the View Code tab, there is nothing written in
the box. I have found that it works like I want if I take a new worksheet and
apply the date formatting to a cell, just not on the worksheet that I had
originally created in 2004.
--
Lee Davenport

"Dave Peterson" wrote:

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson


--

Dave Peterson

Help with formatting the date.
 

Thanks anyway Dave.
--
Lee Davenport


"Dave Peterson" wrote:

You did try the safe mode test, too?

I don't have any other guesses.

Sorry.

Lee wrote:

Dave, That did not work. Under the View Code tab, there is nothing written in
the box. I have found that it works like I want if I take a new worksheet and
apply the date formatting to a cell, just not on the worksheet that I had
originally created in 2004.
--
Lee Davenport

"Dave Peterson" wrote:

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson


--

Dave Peterson