Automatically convert date entry format

[girapas]

In a cell, a user enters a date in this format: ddmmyy
How can that entry be automatically converted in a format like: dd/mm/yyyy after the user hits Enter key.
Thanks in advance

 

[Akashwani]

Hi,

Have you tried formatting the cell before data is entered?
Right click the cell.
Select Format Cells.
Click Date.
Select the required format.
Click Ok.

I hope that helps.
Good luck.

Ak

 

[girapas]

Unfortunately, that doesn't help. Having format date as dd/mm/yyyy when I enter e.g. 251112 I get 08/07/2587

 

[MARK858]

Try custom formatting as

##"/"##"/20"##

 

[Akashwani]

Thanks for that Mark,

I wondered what I was doing wrong with Custom Format!
I was missing the "

Thanks

Ak

 

[MARK858]

Glad it gave a pointer (and glad I eventually remembered to put in the 20)

 

[Rick Rothstein]

In a cell, a user enters a date in this format: ddmmyy
How can that entry be automatically converted in a format like: dd/mm/yyyy after the user hits Enter key.
Thanks in advance

Just so you know, custom formatting that value will not make it an actual date... it will only look like a date... the underlying value in the cell will be the exact number the user typed in. We can do what you want using event code, but first we need to know what cell or cells do you want this automatic conversion to take place in?

 

[girapas]

OK! Thank you very much.