How do I set the date to change into the right format?

[Tab In The Office]

I need to be able to type 15/06/06 or 150606 and for it to change to
15-jun-06 when I leave the cell. I have tried all kinds of things, and
usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can
someone please tell me how to format the date cell properly? I have so many
cover sheets to type for the month end...!Thank you!

 

[HEK]

Did you try to format your cells to the format you want, in your case
Format/Cells/Date/[*chosse*]?
Henk

 

[Tab In The Office]

Yes I did, and was only able to get it to work if I typed the month before
the day (for example, 12/06/06 came out 06-dec-06, instead of 12-jun-06). I
tried a variety of formulas and created some too, but I didn't get it right!
Thanks for your help! Tabitha

Did you try to format your cells to the format you want, in your case
Format/Cells/Date/[*chosse*]?
Henk

I need to be able to type 15/06/06 or 150606 and for it to change to
15-jun-06 when I leave the cell. I have tried all kinds of things, and
usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can
someone please tell me how to format the date cell properly? I have so many
cover sheets to type for the month end...!Thank you!

 

[HEK]

Tabitha: I think you can solve yr problem by Windows settings, not Excel
settings. Go to the Start Menu/Settings/Control Panel/Regional settings and
choose for instance English (UK) instead of (US).
HTH,
Henk

Yes I did, and was only able to get it to work if I typed the month before
the day (for example, 12/06/06 came out 06-dec-06, instead of 12-jun-06). I
tried a variety of formulas and created some too, but I didn't get it right!
Thanks for your help! Tabitha

Did you try to format your cells to the format you want, in your case
Format/Cells/Date/[*chosse*]?
Henk

I need to be able to type 15/06/06 or 150606 and for it to change to
15-jun-06 when I leave the cell. I have tried all kinds of things, and
usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can
someone please tell me how to format the date cell properly? I have so many
cover sheets to type for the month end...!Thank you!

 

[Tab In The Office]

Thank you for your help, Henk!

Tabitha: I think you can solve yr problem by Windows settings, not Excel
settings. Go to the Start Menu/Settings/Control Panel/Regional settings and
choose for instance English (UK) instead of (US).
HTH,
Henk

Yes I did, and was only able to get it to work if I typed the month before
the day (for example, 12/06/06 came out 06-dec-06, instead of 12-jun-06). I
tried a variety of formulas and created some too, but I didn't get it right!
Thanks for your help! Tabitha

Did you try to format your cells to the format you want, in your case
Format/Cells/Date/[*chosse*]?
Henk

:

I need to be able to type 15/06/06 or 150606 and for it to change to
15-jun-06 when I leave the cell. I have tried all kinds of things, and
usually, it stays as I typed it, or it shows like I type it mm-dd-yy. Can
someone please tell me how to format the date cell properly? I have so many
cover sheets to type for the month end...!Thank you!