Override Excel's date autoannoyance

K

Kreller

When I want to insert the timespan 9-16 in a cell, Excel interprete
this data as a date. No matter how I redefine the cell proporties o
change autocorrect proporties I can't seem to make excel stop thi
quite annoying habit, resulting in either in the date 01-09-2016 or
when changing the cell proporties to "number" - 42614. Do you have
solution?
 
F

Frank Kabel

Hi
either format the cell as 'Text' prio to entering these values or enter
them with a leading apostrophe. e.g.
'9-16
 
K

Kreller

Thanks for the reply. I actually have done that, but I don't think it i
a sustainable solution - can it really be that excel is perdestined t
make this weird interpretation without any possibility of reall
turning it off
 

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

Inserting a button into a cell and linking it to a macro 3
Excel 2007 AutoCorrect/Format - Date 4
Date numbers convert to formula 9
Excel keeps converting text to date format 4
Excel Date Format - users should be able to override it automatic. 6
random date when i didn't ask for it! driving me CRAZY! 5
Date Difference 2
Date pasted web site causing inconsistent date format 2

Top