Is there a custom date format that will change dates like Mar. 4 and April
25th to m/d? Anything I try isn't changing the format; I suppose because
Excel doesn't recognize these as a date. I'm using Excel 2007. Thank you.

Alex --

Select the cell or range, then click the little button next to the 'number'
formatting on the 'Home' tab. When the 'format cells' window opens, go to
the 'number' tab and click the 'custom' category on the left-hand side.
Then, in the 'type' field, change it to "m/d". You can also start the whole
process by right-clicking on the range.

HTH

"Alex" wrote:

Is there a custom date format that will change dates like Mar. 4 and April
25th to m/d? Anything I try isn't changing the format; I suppose because
Excel doesn't recognize these as a date. I'm using Excel 2007. Thank you.

Thanks. Did you try this because this is the first thing I tried and can't
get it to work. Maybe I'm doing something wrong.

"pdberger" wrote:

Alex --

Select the cell or range, then click the little button next to the 'number'
formatting on the 'Home' tab. When the 'format cells' window opens, go to
the 'number' tab and click the 'custom' category on the left-hand side.
Then, in the 'type' field, change it to "m/d". You can also start the whole
process by right-clicking on the range.

HTH

"Alex" wrote:

Is there a custom date format that will change dates like Mar. 4 and April
25th to m/d? Anything I try isn't changing the format; I suppose because
Excel doesn't recognize these as a date. I'm using Excel 2007. Thank you.

Alex --

I did try it, and it worked. I wonder if you've entered the date in a way
that makes Excel think it's text, rather than a number?

"Alex" wrote:

Thanks. Did you try this because this is the first thing I tried and can't
get it to work. Maybe I'm doing something wrong.

"pdberger" wrote:

Alex --

Select the cell or range, then click the little button next to the 'number'
formatting on the 'Home' tab. When the 'format cells' window opens, go to
the 'number' tab and click the 'custom' category on the left-hand side.
Then, in the 'type' field, change it to "m/d". You can also start the whole
process by right-clicking on the range.

HTH

"Alex" wrote:

Is there a custom date format that will change dates like Mar. 4 and April
25th to m/d? Anything I try isn't changing the format; I suppose because
Excel doesn't recognize these as a date. I'm using Excel 2007. Thank you.

All I did was type Feb. 5 and format it m/d and it still shows as Feb. 5.
Tried it in two sheets.

"pdberger" wrote:

Alex --

I did try it, and it worked. I wonder if you've entered the date in a way
that makes Excel think it's text, rather than a number?

"Alex" wrote:

Thanks. Did you try this because this is the first thing I tried and can't
get it to work. Maybe I'm doing something wrong.

"pdberger" wrote:

Alex --

Select the cell or range, then click the little button next to the 'number'
formatting on the 'Home' tab. When the 'format cells' window opens, go to
the 'number' tab and click the 'custom' category on the left-hand side.
Then, in the 'type' field, change it to "m/d". You can also start the whole
process by right-clicking on the range.

HTH

"Alex" wrote:

Is there a custom date format that will change dates like Mar. 4 and April
25th to m/d? Anything I try isn't changing the format; I suppose because
Excel doesn't recognize these as a date. I'm using Excel 2007. Thank you.

It's the period. That's making Excel think you're typing text, rather than a
number to be formatted as a date. Just type "Feb 5" and you should be fine.

"Alex" wrote:

All I did was type Feb. 5 and format it m/d and it still shows as Feb. 5.
Tried it in two sheets.

"pdberger" wrote:

Alex --

I did try it, and it worked. I wonder if you've entered the date in a way
that makes Excel think it's text, rather than a number?

"Alex" wrote:

Thanks. Did you try this because this is the first thing I tried and can't
get it to work. Maybe I'm doing something wrong.

"pdberger" wrote:

Alex --

Select the cell or range, then click the little button next to the 'number'
formatting on the 'Home' tab. When the 'format cells' window opens, go to
the 'number' tab and click the 'custom' category on the left-hand side.
Then, in the 'type' field, change it to "m/d". You can also start the whole
process by right-clicking on the range.

HTH

"Alex" wrote:

Is there a custom date format that will change dates like Mar. 4 and April
25th to m/d? Anything I try isn't changing the format; I suppose because
Excel doesn't recognize these as a date. I'm using Excel 2007. Thank you.