Try to enter date; get ###
 

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

Try to enter date; get ###
 

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

Try to enter date; get ###
 

Try widening the column

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Matthew W. I. Dunn" wrote in
message ...
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 ###?

Try to enter date; get ###
 

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

Try to enter date; get ###
 

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 Phillips" wrote:

Try widening the column

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Matthew W. I. Dunn" wrote in
message ...
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 ###?

Try to enter date; get ###
 

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

Try to enter date; get ###
 

Make the font smaller.

You can enter '9/10 (note the leading apostrophe), but then that cell doesn't
contain a date anymore--it's just text that looks like a date.

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

--

Dave Peterson

Try to enter date; get ###
 

Sorry for asking a simple question (I usually don't use Excel):

But, how do I format as month/day?

Thanks.





"David Biddulph" wrote:

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

Try to enter date; get ###
 

FormatCellsNumber tabCustom m/d


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 12:12:17 -0700, Matthew W. I. Dunn
wrote:

Sorry for asking a simple question (I usually don't use Excel):

But, how do I format as month/day?

Thanks.





"David Biddulph" wrote:

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