Typing in the term 1-30 in a cell always returns the date Jan-30. I
understand date formatting but I would like to display the term 1-30. The
next cell is 31-60 and displays properly. How do I do this. Thankyou.

pre-format as text or use ' before

--
Don Guillett
SalesAid Software

"Hank" wrote in message
...
Typing in the term 1-30 in a cell always returns the date Jan-30. I
understand date formatting but I would like to display the term 1-30. The
next cell is 31-60 and displays properly. How do I do this. Thankyou.

Type an apostrophe first then the 1-30

Or pre-format the cells to Text.


Gord Dibben MS Excel MVP

On Sun, 10 Sep 2006 15:30:01 -0700, Hank wrote:

Typing in the term 1-30 in a cell always returns the date Jan-30. I
understand date formatting but I would like to display the term 1-30. The
next cell is 31-60 and displays properly. How do I do this. Thankyou.

Thank you for the help. The answer was so simple that I couldn't see it. Not
even after 2 days of looking. Thank you, again.

"Hank" wrote:

Typing in the term 1-30 in a cell always returns the date Jan-30. I
understand date formatting but I would like to display the term 1-30. The
next cell is 31-60 and displays properly. How do I do this. Thankyou.