Excel 07 Oddity - newly entered dates are turning into formulas - huh?

jkalpus

New Member
Joined
Apr 17, 2004
Messages
46
Greetings ...A client recently showed me an Excel 07 worksheet that's exhibiting really odd behavior. When a DATE is entered into a cell, either manually or with a function (Like 5/5/2001), the cell returns a decimal. For example: if you enter 5/5/2005 into a cell, you see this in the formula bar: =5/5/2005, which returns 0.000498753 in the cell - INSTEAD of the date! Where is this "=" sign coming from??? There isn't any code attached to the sheet, and all the options seems to be normalized. FYI, when other sheets are added to the workbook, they all behave normally.
Any clues? I'm stumped! - John
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Although not currently at my XL2007 machine, from my (66-yr-old) memory, try this: Click the Office Button, then at the bottom of the dropdown click on Excel Options, then click on the Advanced group, and look for Transition Keys (or some such wording, with "Transition" in it. Change the setting here, and then test your sheet. Should do the trick.
Larry
 
Upvote 0
Hi Larry ... yup, THAT did the trick! Thanks! Wouldn't you know it, that was the ONE thing I didn't try. I was reasonably sure the fix was somewhere in the Options menu. There's ole Lotus 1-2-3 back to haunt all of us. Thanks, again ... John
 
Upvote 0

Forum statistics

Threads
1,207,423
Messages
6,078,443
Members
446,338
Latest member
AliB

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top