number keep being formatted as date
 

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.


--
baxu
------------------------------------------------------------------------
baxu's Profile: http://www.excelforum.com/member.php...o&userid=27861
View this thread: http://www.excelforum.com/showthread...hreadid=473657

You can format the cells to text and then you should be able to enter
the information as 1-2 and get the result expected. Simply select the
destination cells an go to FormatCellsNumberText. Hope this is what
you are looking for.


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=473657

this is exactly what I was looking for. your solution is right on the
spot! :) :cool:


--
baxu
------------------------------------------------------------------------
baxu's Profile: http://www.excelforum.com/member.php...o&userid=27861
View this thread: http://www.excelforum.com/showthread...hreadid=473657