when i write in cell 2-2 or 1-2 whatever it is change to date whi.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever i enter 2-1 or 3-1 etc into a cell, Excel automatically changes it
to a date, which i don't want to change to date i want it as 2-2 or
2-1wahtever .when i simply want to display 2-1 etc. However if i change the
formatting in that cell back to general, it interprets that as a 5 digit
number, e.g. 38408. How do i turn this auto-edit feature off?
 
Format the cell as text before you enter the data. Or precede the data with
a single quote; it will not show but it will cause the data to be
interpreted as text.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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

This cell contains a date string rep. with only 2 digits for the y 5
Excel Data pastes into 2 cells not 1 1
why do 2 cells highlight when I only select 1? 2
Which 2 in 1 or laptop for 6 year old ? 8
Excel VBA to move cells to sheet2 based on selection in sheet1 0
How 2 change date in 1 cell/worksheet so it changes in all workshe 2
adding text according to col with equal date 2
Changing the Status of Cell 1

Back
Top