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

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!

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

"Tab In The Office" wrote:

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

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

"HEK" wrote:

> Did you try to format your cells to the format you want, in your case
> Format/Cells/Date/[*chosse*]?
> Henk
>
> "Tab In The Office" wrote:
>
> > 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!

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


"Tab In The Office" wrote:

> 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
>
> "HEK" wrote:
>
> > Did you try to format your cells to the format you want, in your case
> > Format/Cells/Date/[*chosse*]?
> > Henk
> >
> > "Tab In The Office" wrote:
> >
> > > 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!

Thank you for your help, Henk!

"HEK" wrote:

> 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
>
>
> "Tab In The Office" wrote:
>
> > 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
> >
> > "HEK" wrote:
> >
> > > Did you try to format your cells to the format you want, in your case
> > > Format/Cells/Date/[*chosse*]?
> > > Henk
> > >
> > > "Tab In The Office" wrote:
> > >
> > > > 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!