Excel: = sign keeps coming up when i enter 7/1 for date

B

BrandonAma

There is a bug in my file. When i enter "7/1" for a date of July 2006, i get
"7" instead. Looking at the formula bar shows "=7/1". When i go to format
the cell to date, i get "January 1900".

It seems to be happening to 4 of 9 sheets in the work book and in all cells.
 
N

Norman Jones

Hi Brandon,

I could only reproduce your problem if I inadvertently prefixed my entry
with an equals sign.
 
D

Dave Peterson

Try:
tools|options|Transition tab|uncheck Transition Formula Entry

(I'd turn off all those options.)
 

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

Top