Help With a Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Tools>options>transition, deselect transition formula entry, in fact you are
probably better off deselecting evaluation and navigation keys if they are
selected as well
 
Tools>Options>Transition. You are in Lotus entry mode.

Uncheck the transition options checkboxes.



Gord Dibben MS Excel MVP
 
I unchecked the Transition boxes and it works!

Thank to all of you!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF statment help 7
Date formula 4
help with Sum in between dates 9
How to use SumProduct to count reference or something else? 3
I need Help with a date calculator 0
Same Date a year ago 4
IF Dates 1
Excel formular to Count values in cells of rows that meet criteria 7

Back
Top