How can I write 3/5 in a cell and have it look like 03-May back?

[Janneman]

Have tried to write in 3/5 and have it look like 03-May back, but excel
always comes back with 05-March! Have tried to format cells with both dates
and specials and also tried the "text to columns" but nothing works.
Anyone who can solve this problem?

Thanks!

 

[Tim]

Hi,

Right click the cell>Format>Custom>in the "Type:" box type: m/d

Tim

 

[Janneman]

Thank you David!
This worked just fine!

You may need to look at your date format settings in Windows/ Regional
Options (accessed through Control Panel, not Excel). Then try re-entering
the data.

Once the date is stored (as a number), reformatting the cell in Excel will
not change the underlying date stored.

 

[David Biddulph]

Glad it helped.
--
David Biddulph

Thank you David!
This worked just fine!