Date cell automatically turns into formula

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
I am entering 3/05/03 into a cell and have it formatted as a date but the result is 00/0000/1900 of something like that. It appears that after I enter 3/05/03 it puts an = sign in front of it turning it into a formula. Can someone tell me what I'm doing wrong?

Thanks
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Without actually seeing what is happening, I guess I can only recommend that you start with checking the regional settings of both Excel and our Windows date/time keeping.

check also, menu: tools, options - click "International" tab.
 

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
I am typing 4/13/2003 in a cell and it returns 1/0/1900, I am using format Date 3/14/01. The thing that looks funny is it puts an = sign in front of it up in the menu bar even though I didn't type one in front of it, so I think excel thinks it's a formula. I have looked at the " International Tab" but all looks fine.
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Under Tools, Options, click on the Transition tab.
If the item Transition Formula Entry is checked, uncheck it, Click OK.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,989
Members
412,633
Latest member
simon_elvin
Top