I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it. Anytime I
place the date 6/30/2008 into this row excel displays "1/0/1900". I tried to
recreate the problem on other tabs of the workbook, or in new workbooks and I
can't.

What in the world is going on here?

enter 6/30/2008 into a cell that works. Copy this cell and paste it into the
cell that mis-behaves.
--
Gary''s Student - gsnu200753


"diaare" wrote:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it. Anytime I
place the date 6/30/2008 into this row excel displays "1/0/1900". I tried to
recreate the problem on other tabs of the workbook, or in new workbooks and I
can't.

What in the world is going on here?

Are you sure you're not putting an = in front of it? If you do , you will
get a number that rounds to 0. 0 in date format it 1/0/1900.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

?B?ZGlhYXJl?= wrote in
:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it.
Anytime I place the date 6/30/2008 into this row excel displays
"1/0/1900". I tried to recreate the problem on other tabs of the
workbook, or in new workbooks and I can't.

What in the world is going on here?

Are you sure it is not =6/30/2008 which is 6 divided by 30 divided by 2008 (a
very small number)...
--
HTH...

Jim Thomlinson


"diaare" wrote:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it. Anytime I
place the date 6/30/2008 into this row excel displays "1/0/1900". I tried to
recreate the problem on other tabs of the workbook, or in new workbooks and I
can't.

What in the world is going on here?

I couldn't get it to display correctly anywhere on that worksheet.

But I took your suggestion and placed it on a new tab, and then copied the
correct display where I needed it.

Viola! It displayed the correct date. No idea why...but at this point it
doesn't matter.

Thanks,
Diane

"Gary''s Student" wrote:

enter 6/30/2008 into a cell that works. Copy this cell and paste it into the
cell that mis-behaves.
--
Gary''s Student - gsnu200753


"diaare" wrote:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it. Anytime I
place the date 6/30/2008 into this row excel displays "1/0/1900". I tried to
recreate the problem on other tabs of the workbook, or in new workbooks and I
can't.

What in the world is going on here?

My guess would be that this particular sheet has transition turned on under
toolsoptionstransition
and transition formula entry checked. If she clears that checkbox it will
work and it is applied on sheet level so that would explain that it returns
the correct result in another sheet


--


Regards,


Peo Sjoblom



"Jim Thomlinson" wrote in message
...
Are you sure it is not =6/30/2008 which is 6 divided by 30 divided by 2008
(a
very small number)...
--
HTH...

Jim Thomlinson


"diaare" wrote:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it. Anytime
I
place the date 6/30/2008 into this row excel displays "1/0/1900". I
tried to
recreate the problem on other tabs of the workbook, or in new workbooks
and I
can't.

What in the world is going on here?

You all were correct. Excel was automatically putiting an = in from of my
text...and as Peo suggested, when I turned off the Transition Formula entry,
the problem corrected itself.

Now, out of curiousity, I'll have to go read up on this "transition" option.

Thanks again for all of your help.
Diane

"David M. Marcovitz" wrote:

Are you sure you're not putting an = in front of it? If you do , you will
get a number that rounds to 0. 0 in date format it 1/0/1900.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

?B?ZGlhYXJl?= wrote in
:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it.
Anytime I place the date 6/30/2008 into this row excel displays
"1/0/1900". I tried to recreate the problem on other tabs of the
workbook, or in new workbooks and I can't.

What in the world is going on here?

It is a leftover since the days when Lotus 123 was the main spreadsheet and
MS wanted to make it easier for people used to 123 to migrate to Excel. If
you open a spreadsheet originally done in 123 this will be checked by
default unless somebody has cleared the check boxes previously


--


Regards,


Peo Sjoblom


"diaare" wrote in message
...
You all were correct. Excel was automatically putiting an = in from of my
text...and as Peo suggested, when I turned off the Transition Formula
entry,
the problem corrected itself.

Now, out of curiousity, I'll have to go read up on this "transition"
option.

Thanks again for all of your help.
Diane

"David M. Marcovitz" wrote:

Are you sure you're not putting an = in front of it? If you do , you will
get a number that rounds to 0. 0 in date format it 1/0/1900.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

?B?ZGlhYXJl?= wrote in
:

I feel as if someone is playing a cruel joke on me...please help.

I have a row of cells that show dates.

The format is set to date - nothing custom or unusual about it.
Anytime I place the date 6/30/2008 into this row excel displays
"1/0/1900". I tried to recreate the problem on other tabs of the
workbook, or in new workbooks and I can't.

What in the world is going on here?