Quote Originally Posted by David A Coop View Post
How will excel know which month you want? Is it the current month and year?

How many cells are involved?

You could get "auto finish" to kick in, but it would require a macro attached to the cell so that when you type the day, the month and year will appear.

Regards,

David
What I am trying to do is that make just friendly entry so something like that: cell dd/mm/yy was already in that form and you just type e.g. 14 01 15 and it would display 14/01/15 and I want that during typing was shown slashes want to know if that is possible and if so , how?