Format as m/d, if that's what you want.
--
David Biddulph

"Matthew W. I. Dunn" wrote in
message ...
Is it possible to keep the date as text?

I know Excel doesn't like to do that. But, to have the full date
(month/day/2007) in each column or cell would really make the chart
unwieldy.
Typing "9/10" takes up less space.

Any further thoughts would be appreciated. Thanks.



"Bob I" wrote:

make the cell wider

Matthew W. I. Dunn wrote:

I'm trying to enter a date in a cell for an attendance roster I'm
making.

I click a cell and enter "9/10." But, Excel converts it to "###" in
the
cell. The Formula Bar reads "9/10/2007."

What is this ###?