Share via

how to turn off automatic date function on excell

Anonymous
2011-10-29T02:12:30+00:00

Can anybody please explain how to turn off automatic date function on excel

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-10-29T02:37:54+00:00

If by "automatic date function" you mean Excel's tendency to translate entries that appear to be dates, into dates, it cannot be turned off.

If you want to enter a string that looks like a date; e.g:  1-5 , you must either format the cell as text prior to entering the value, or precede the entry with a single quote  (e.g '1-5) which will not show up on the worksheet itself, but tells Excel to treat the entry as text.

joeu recently quoted the Serenity Prayer by Niebuhr, which is applicable here:

Grant me the serenity to accept the things I cannot change,

Courage to change the things I can,

And wisdom to know the difference.

Was this answer helpful?

2 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest