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

Paste to excel from word - auto format problem 1
Black Lines appearing over table borders 0
How can i extract certain text out a cell and copy it to ther cells 1
Auto Populate One Pages from spreadsheet 0
Add additional information to excel form after original data entry 0
Document Merge Formatting Issue 0
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
Merging from an Excel file with graphics 1

Top