Date format in cell

K

klappin

I am trying to put a date in a cell, but the cell keeps formatting the
numbers with a = sign before them turning it into a formula. How can I stop
it from doing this? I've already cleared all formats from the cell.

1/1/09 turns into =1/1/9 with a result of 0.1111111111

Thanks
 
T

T. Valko

Check this setting:

Tools>Options>Transition tab>Transition formula entry

Uncheck that setting>OK
 

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

conditional format cells by date 2
Conditional Formating with IF and AND formula 2
Auto date in excell 2010 4
Conditional formatting in Excel 2010 2
Financial rear date ranges in a single cell 2
Custom Date Format 3
Sumproduct Date Format Question 6
putting date in a cell referring to the tab sheet 1

Top