MrExcel Publishing
Your One Stop for Excel Tips & Solutions

strange things happening in my spreadsheet, need some help

Posted by Kevin on December 28, 2001 8:03 AM

I have an excel file that was emailed to me from our accountants. Whenever I try to type a date in a cell, for example if I type 12/31/01, instead of automatically converting it to a date, 12/31/2001, it puts an = sign in front and returns =12/31/1, or .387096774. This doesn't happen in any of my other spreadsheet files. Why is it doing this with this file, and how can I stop it?


Posted by John on December 28, 2001 9:34 AM

Go to Tools -> Options -> Transition
and uncheck "Transition Formula Entry"

Posted by Kevin on December 28, 2001 2:12 PM

thank you