Date in short form

[kevs]

I'm trying to just put month/year, in short form to make column THIN.

I choose: M-01

But when I put 11/03, Excel puts N-04 into the column?????

OS 10.3.5
Office 2004

 

[Daiya Mitchell]

M-01 appears to be not Month-Year, but "first letter of month-year." Notice
their sample uses March. I don't see an example of 3/01, which is what it
would need to be to get what you want via Format | Cells, Date. It does
seem a surprising omission, but perhaps there's a more convoluted way to do
it?

DM

 

[Bernard Rey]

kevs wrote :

I'm trying to just put month/year, in short form to make column THIN.

I choose: M-01

But when I put 11/03, Excel puts N-04 into the column?????

Think that the way the date is displayed is one thing, and the way you enter
it another thing. When you enter "11/03" Excel will consider this as
"11/03/04" whatever the cell is formatted to.

If you want it to display "N-03" in your case, you have to enter "11/01/03".
Or "11/2003" if you prefer.