Help With a Date
 

I am entering

12/31/06
Enter

in a cell and the spreadsheet is inserting and ='s sign before the 12 and
performing the calculation 12 divided by 31 divided by 6. The only way to
get the date to display has been to enter an apostaphe before the 12.

This only happens in this particular spreadsheet. I have looked through the
Options but I don't see anything obvious - does anyone know how to fix this?

Many Thanks,

Help With a Date
 

Have you tried to format that cell using various date formats?

"lk" wrote in message
...
I am entering

12/31/06
Enter

in a cell and the spreadsheet is inserting and ='s sign before the 12 and
performing the calculation 12 divided by 31 divided by 6. The only way to
get the date to display has been to enter an apostaphe before the 12.

This only happens in this particular spreadsheet. I have looked through
the
Options but I don't see anything obvious - does anyone know how to fix
this?

Many Thanks,

Help With a Date
 

Toolsoptionstransition, deselect transition formula entry, in fact you are
probably better off deselecting evaluation and navigation keys if they are
selected as well


--
Regards,

Peo Sjoblom


"lk" wrote in message
...
I am entering

12/31/06
Enter

in a cell and the spreadsheet is inserting and ='s sign before the 12 and
performing the calculation 12 divided by 31 divided by 6. The only way to
get the date to display has been to enter an apostaphe before the 12.

This only happens in this particular spreadsheet. I have looked through
the
Options but I don't see anything obvious - does anyone know how to fix
this?

Many Thanks,

Help With a Date
 

(tools<options<transition Clear any check boxes

"lk" wrote:

I am entering

12/31/06
Enter

in a cell and the spreadsheet is inserting and ='s sign before the 12 and
performing the calculation 12 divided by 31 divided by 6. The only way to
get the date to display has been to enter an apostaphe before the 12.

This only happens in this particular spreadsheet. I have looked through the
Options but I don't see anything obvious - does anyone know how to fix this?

Many Thanks,

Help With a Date
 

ToolsOptionsTransition. You are in Lotus entry mode.

Uncheck the transition options checkboxes.



Gord Dibben MS Excel MVP


On Mon, 9 Apr 2007 11:36:02 -0700, lk wrote:

I am entering

12/31/06
Enter

in a cell and the spreadsheet is inserting and ='s sign before the 12 and
performing the calculation 12 divided by 31 divided by 6. The only way to
get the date to display has been to enter an apostaphe before the 12.

This only happens in this particular spreadsheet. I have looked through the
Options but I don't see anything obvious - does anyone know how to fix this?

Many Thanks,

Help With a Date
 

I unchecked the Transition boxes and it works!

Thank to all of you!

"Gord Dibben" wrote:

ToolsOptionsTransition. You are in Lotus entry mode.

Uncheck the transition options checkboxes.



Gord Dibben MS Excel MVP


On Mon, 9 Apr 2007 11:36:02 -0700, lk wrote:

I am entering

12/31/06
Enter

in a cell and the spreadsheet is inserting and ='s sign before the 12 and
performing the calculation 12 divided by 31 divided by 6. The only way to
get the date to display has been to enter an apostaphe before the 12.

This only happens in this particular spreadsheet. I have looked through the
Options but I don't see anything obvious - does anyone know how to fix this?

Many Thanks,