Date format changes to formula

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

Guest

Got a weird one. I set the date format in a cell. Then if I type the date in
mm/dd/yy format it coverts to a formula. It looks like this in the cell:
01/00/00 and the formula bar show this: =10/19/6

I've tried setting all different date formats but it is still spontaneously
switching to a formula and not displaying as a date.

Ideas?
 
Tools>Options>Transition.

Uncheck the all three Transition options.

i.e. navigation, formula evaluation, formula entry.


Gord Dibben MS Excel MVP
 
What date format did you set it to....
just to make sure you are not typing in the equal sign in correct?
 
Thanks a million, that worked perfectly!


Gord Dibben said:
Tools>Options>Transition.

Uncheck the all three Transition options.

i.e. navigation, formula evaluation, formula entry.


Gord Dibben MS Excel MVP
Click to expand...
 

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

Excel 2002: How to make the date format uniform ? 1
Date Time formatting problem 7
Excel 2007 displayed dates 2
htm date & time format 11
Preserving date format 1
date format 1
Pivot Table date format 1
Format displays 1

Back
Top