How do I stop Excel from auto-inserting a date?

S

Samson Huang

I am trying to type in 12-56 but Excel continues to format the cell into
Dec-56. How do I stop this from happening?
 
D

Dave Peterson

Preformat the cell as text, then do the data entry.

Or

Start your entry with an apostrophe: '12-56
 

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

Formating time when pasting from PDF to excel? 1
Auto Correct 3
How do I summarize unusual column data? 4
Dates and Cell Values 3
Format time column to remove dates 4
to find the repetitve text from a column. 4
How can I stop Excel from formating my infromation as a Date? 2
Time Values As Numbers 3

Top