I am trying to enter in a date, let's say 7/7/07 into a cell. Excel is then
taking this date and putting an = in front of this date. It is also
replacing the 07 with just a 7. I have tried formatting the cell as a date
format and the result is if 7/7/07 is keyed in, it drops the 07 for 7 and
returns 01/00/00. It is still putting the = sign in front of the numbers
like this is a formula.

I know if you put a ' in front of the date it will not do this, but I am
trying to use the date as a basis for another calculation...7/7/07-28.

Can anyone help with this? It only does this on certain spreadsheets.

On Wed, 18 Jul 2007 08:56:02 -0700, jedmo1640
wrote:

I am trying to enter in a date, let's say 7/7/07 into a cell. Excel is then
taking this date and putting an = in front of this date. It is also
replacing the 07 with just a 7. I have tried formatting the cell as a date
format and the result is if 7/7/07 is keyed in, it drops the 07 for 7 and
returns 01/00/00. It is still putting the = sign in front of the numbers
like this is a formula.

I know if you put a ' in front of the date it will not do this, but I am
trying to use the date as a basis for another calculation...7/7/07-28.

Can anyone help with this? It only does this on certain spreadsheets.

On the spreadsheets where this occurs, select:

Tools/Options Transition
DESelect "Transition Formula Entry"


--ron

Toolsoptionstransition, deselect transition formula entry
in fact deselect any check marks since they all can give you hiccups later
on

By using this (from Lotus 123) it tells Excel to divide 7 by 7 by 7 just
like you would enter

=7/7/7


--
Regards,

Peo Sjoblom



"jedmo1640" wrote in message
...
I am trying to enter in a date, let's say 7/7/07 into a cell. Excel is
then
taking this date and putting an = in front of this date. It is also
replacing the 07 with just a 7. I have tried formatting the cell as a
date
format and the result is if 7/7/07 is keyed in, it drops the 07 for 7 and
returns 01/00/00. It is still putting the = sign in front of the numbers
like this is a formula.

I know if you put a ' in front of the date it will not do this, but I am
trying to use the date as a basis for another calculation...7/7/07-28.

Can anyone help with this? It only does this on certain spreadsheets.

Thank you both...it was driving me nuts!!

"Peo Sjoblom" wrote:

Toolsoptionstransition, deselect transition formula entry
in fact deselect any check marks since they all can give you hiccups later
on

By using this (from Lotus 123) it tells Excel to divide 7 by 7 by 7 just
like you would enter

=7/7/7


--
Regards,

Peo Sjoblom



"jedmo1640" wrote in message
...
I am trying to enter in a date, let's say 7/7/07 into a cell. Excel is
then
taking this date and putting an = in front of this date. It is also
replacing the 07 with just a 7. I have tried formatting the cell as a
date
format and the result is if 7/7/07 is keyed in, it drops the 07 for 7 and
returns 01/00/00. It is still putting the = sign in front of the numbers
like this is a formula.

I know if you put a ' in front of the date it will not do this, but I am
trying to use the date as a basis for another calculation...7/7/07-28.

Can anyone help with this? It only does this on certain spreadsheets.