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

H

haniht

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?
 
N

Niek Otten

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
 
Top