number keep being formatted as date

  • Thread starter Thread starter baxu
  • Start date Start date
B

baxu

Hi:

I'm a newbie so forgive me if this question has been answered. I
couldn't find much with the search option.

Okay here's the problem.:confused: :eek:

I want to enter this: 1-2 into a cell but Excel keep turning it into
2-Jan. How do I turn this off?

the 1-2 is just a designation of point 1 to point 2.

Thank you for helping.
 
You can format the cells to text and then you should be able to ente
the information as 1-2 and get the result expected. Simply select th
destination cells an go to Format>Cells>Number>Text. Hope this is wha
you are looking for
 
Back
Top