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

J

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!
 
D

David Biddulph

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.
 
J

Janneman

Thank you David!
This worked just fine!

David Biddulph said:
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.
Click to expand...
 
Top