Disabling Automatic Date Thing

  • Thread starter Thread starter MAtt
  • Start date Start date
M

MAtt

When i type '5-10' for example, and then press enter or leave that box, the
'5-10' i typed automatically changes to '05-Oct'. It's really irritating and
it happens with others, such as '10-15', basically anything that looks like a
date.

How do I turn this off?
 
How do I turn this off?

Unfortunately, you can't.

What you can do is precede the entry with an apostrophe like: '5-10. The
apostrophe will not display in the cell.

Or, you can pre-format the cells as TEXT.
 
You must log in or register to reply here.

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

Turn off automatic date formatting? 3
Excel check if dates are under a range of week 4
Lookup a particular cell in another excel workbook 1
Excel Vba to change displayed year automatically. 14
SUMIFS with Dates 1
Add up a value that meets 2 criteria 5
Add 45 days to a date.... 3
Date Issue 4

Back
Top